Notifications
Clear all
Topic starter
Hello,
I would like to know how could you simultaneously transpose an entire table like the attached to have the rows as columns and the columns as rows.
I would greatly appreciate your assistance on this matter.
Sincerely.
Carlos Solis
Posted : 09/01/2019 9:32 am
Hi Carlos
1) Copy the required range eg A2:AA12
2) Select a cell eg A14
3) Select Home - Paste - Paste Special - Transpose
Hope this helps
Sunny
Posted : 09/01/2019 11:23 am