Transpose Data in Excel | 5 Methods | Shift Data from Rows to columns or Vice versa

[@anv.4614]

Thank yiz Hasaan, amazing tricks. they enable to save a lot of times.

[@TheOludave239]

Great work 👍

[@carolleekruger4579]

I enjoy your teachings on Excel. I prefer pictures and text, as it makes it easier to use while I am in the office. They are wonderfully helpful.

[@LonestarPaul]

Hi Hasaan, Same comment here - I like articles better! Still I am grateful for all this no matter what. Thank you!

[@HasaanFazal]

Appreciate your kind words. Happy that it's helping :)

[@gustavefrancois776]

The best bro! Thank you

[@selimdu]

THANKS LOT

[@jendrasingh]

Hi Hassan, thanks for sharing. I have notes in rows that i would like to put in coloums and then change he formula to transpose. Thanks

[@khalidmajeed2886]

sir my data is-------1stcolumn qt , 2ndcolumn value ,3rdColumn qt ,4th column is value how can i transpose, jazakallah.

[@HasaanFazal]

You should be able to transpose like normal. But seems you are requiring a different arrangement? Can you explain further how do you want your final data to appear?