Please apply this utility by clicking Kutools > Range Converter > Transform Range, see screenshot: Here we take the following screenshot for example to change the single row to columns Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. If you install Kutools for Excel, you can quickly change the selected range or single row to columns by the feature of Transform Range. To change multiple columns into multiple rows as following screenshot in Excel:īy using the Paste option Transpose command, you can easily change multiple columns into multiple rows like so:Ĭhange range or single row to column with Kutools for Excel Using Paste option Transpose command to paste.Ĭhange multiple columns to multiple rows in Excel If you want to change a column data into a row in Excel as following screenshot:īy using the Paste option Transpose command, you can easily change a column into a row like so:ģ. Using the Paste option Transpose command to paste.

Select a cell you want to paste and right click it.ģ. Suppose you have multiple rows data in Excel as following screenshot need to be changed into multiple columns in Excel.īy using the Paste option Transpose command, you can easily change multiple rows into multiple columns like so:Ģ. You can quickly access Paste option Transpose command from the right click menu as:Ĭhange multiple rows to multiple columns in Excel It will change the row into a column like so: Suppose you have a row data in Excel as following screenshot need to be changed into a column in Excel.įirstly, please select and copy the row, then select a cell where you want to paste the data and right click it, and choose to paste the data with Paste option Transpose command. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!

Change columns to rows in excel