LinkBack URL
About LinkBacks
How do I transpose a horizontal reading excel into a vertical reading excel and transpose all of the data and formulas?
How do I transpose a horizontal reading excel into a vertical reading excel and transpose all of the data and formulas?
Copy the data>>Place the cursor in blank cell>>Press Alt+E+S (To get the Paste Special Dialog Box)>>Click Transpose>>Press Ok...
But you can't transpose the formula's. It works with the data alone.
I believe, you have to go for VBA approach for transposing both data & formulas
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks