Excel Move Data from Column to Row and Vice-versa - Easy Trick

Excel Move Data from Column to Row and Vice-versa 

If you have data in horizontal format and you want to move the same in vertical format or vice-versa, in other words you want to move data from column to row or vice-versa then follow below simple steps.

It is very easy to follow below steps rather than enter them manually.

In above image you can see date is in horizontal format in column but we want to transfer them in vertical format in Row then copy data and select any cell where you want data.

Right click and select option Paste special then tick on transpose option. After Tick on transpose option hit on OK.

Now you can see all values are transfer to vertical format in Rows.

Hope you understand how to Excel Move Data from Column to Row and Vice-versa.

Thank you.

Watch Video -

Have a nice Day… Enjoy Excelling…