copy vertical data and paste it horizontally in excel

#COPY VERTICAL DATA AND PASTE IT HORIZONTALLY IN EXCEL CODE#

Verify these formulas use absolute references-if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement.

With a VBA macro code, you can copy and paste it once within the workbook in the VBA editor. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Flip the Data Vertically (Reverse Order Upside Down). Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Run the macro (F5).

#COPY VERTICAL DATA AND PASTE IT HORIZONTALLY IN EXCEL CODE#

Select the checkbox Transpose, and click OK. Open the Microsoft Visual Basic for Applications window (Alt + F11).Click Insert > Module, and paste the above code in the Code window. Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose 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. Alternatively, you can right-click on the cell and select Paste Special from the menu.

Copy vertical data and paste it horizontally in excel