Convert data with rows into columns

[Closed]
Report
Posts
2
Registration date
Monday April 2, 2018
Status
Member
Last seen
April 2, 2018
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I wanted to convert huge amount of data with rows into columns , with few conditions
please let me know if you can help.





2 replies


Its called a pivot table. There we helped!

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Pooja.bs,

Changing rows into columns (or vice versa) is called 'Transposing' and is an option when pasting data (paste special).

Best regards,
Trowa