Rotate 7 Column Names within the same 7 columns

[Frank Vance]

To the community. I am trying to help my wife who is a school teacher. I have created a spreadsheet that rotates the 7 columns in excel. When I tried moving it to google sheets my rotate button does not work. I have attached a sample spreadsheet of what I need to be able to do in google sheets with a rotate function button. Thanks for your support.

[Hassam Saeed]

Hey Frank,

Your file seems to have a macro.

Even though I wasn't able to test that out as I don't have excel but apparently what you are looking for can be acheived through:

1. Transpose function

2. Google Apps Script to transform that.

Thanks