Convert data with rows into columns

Closed
pooja.bs Posts 1 Registration date Monday 2 April 2018 Status Member Last seen 2 April 2018 - 2 Apr 2018 à 04:47
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Apr 2018 à 11:38
Hello,

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





Related:

2 responses

Blocked Profile
2 Apr 2018 à 16:47
Its called a pivot table. There we helped!

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
3 Apr 2018 à 11:38
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