Convert data with rows into columns

Closed
pooja.bs Posts 2 Registration date Monday April 2, 2018 Status Member Last seen April 2, 2018 - Updated on Apr 2, 2018 at 05:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 3, 2018 at 11:38 AM
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 responses

Blocked Profile
Apr 2, 2018 at 04:47 PM
Its called a pivot table. There we helped!

0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 3, 2018 at 11:38 AM
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
0