I have three columns of data formatted on the sheet horizontally but I need to use that data on a different sheet, vertically. Is there an quick way to change from horizontal to verical and vice versa? Thanks! Jett
I have three columns of data formatted on the sheet horizontally but I need to use that data on a different sheet, vertically. Is there an quick way to change from horizontal to verical and vice versa? Thanks! Jett
Transpose I suppose....
Copy the data and then paste it with
Edit >Paste Special > tick "Transpose"
Perfect! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks