Help Needed Rotate Excel Sheet from Landscape to Portrait

Copper Contributor

I need help! I created a worksheet but need to switch the top row (the ages) to the side column row where the 5 main categories are. Is this possible without having to move and redo the entire sheet? There is information already in the sheet. 

1 Reply

@cf365-0330_May , insert empty column, select the range from your top row you'd like to transform, Copy, stay on first cell of the new column, Paste->Paste special->Transform