Forum

Notifications
Clear all

Simultaneously transposing a complete table

2 Posts
2 Users
0 Reactions
85 Views
(@crszen)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: