How to convert the place of rows and columns

Excel Help for How To Convert The Place Of Rows And Columns in Analyzing Corporate Financial Data

How To Convert The Place Of Rows And Columns

Rate this: (3/5 from 1 vote)

	Could you, please, tell me, what formula should I put to replace the rows with the columns and vise versa?
	Posted by Andrew Perkins on 24 Sep 2021

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	Transpose data Rate this: (3.5/5 from 2 votes) This seems like more of a Copy and Paste Special > Transpose which will swap rows with columns and vice-versa.
	Excel Business Forums Administrator
	Posted by Excel Helper on 24 Sep 2021

How to convert the place of rows and columns Rate this: (3/5 from 1 vote) Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C. Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose Tranpose button image. After rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Regards, Peter

Posted by petergroft on 10 Nov 2022

Displaying page 1 of 1