View original (French)

Transpose rows and columns in an Excel table

Solved
Nkalinda Posted messages 17 Registration date   Status Membre Last intervention   -  
DjiDji59430 Posted messages 4276 Registration date   Status Membre Last intervention   -
Hello,

I created an EXCEL table: 12 rows x at least 100 columns.
After completing my data, I realized that my table is unusable because I should have done the opposite: 12 columns and a hundred rows.

How can I modify it without losing my data (by swapping the axes and adjusting the cells so they correspond to my previous axes)?

For examples:
Before
My table / January / February / March / April
pears / 4 / 2 / 6 / 8
apples / 66 / 212 / 459 / 358
plums / 26 / 22 / 56 / 365

What I want
My wish / pears / apples / plums
January / 4 / 66 / 26
February / 2 / 212 / 22
March / 6 / 459 / 56
April / 8 / 358 / 365

Thank you in advance.

2 réponses

Réponse 1 / 2
Ruru
 
Hello,

it's even simpler than that, you just need to copy your table, right-click your mouse, then click on Paste Special, and choose the icon that indicates axis inversion.

For more details, here’s a very useful link: http://www.pcastuces.com/pratique/astuces/2757.htm
6
MNO
 

Thank you thank you thank you !!

0