Transpode Multiple Columns into Multiple Rows

[ElsiePOA]

I have a spreadsheet with 4000 columns. Each column has 25 cells of data. I need a macro to transpose these columns into 4000 rows, each row having 25 cells of data

[djbomaha]

Hi Elsie,

Here is a routine you can try. It will transpose the data on the first sheet on a sheet it adds right after it. It captures all the data on the sheet, so it shouldn't matter how many rows and columns you have.

The code for the routine is given below. I have attached the sample workbook along with it. To run the macro to transpose the data, hit "<CTRL> t", to reset the workbook, hit "<CTRL> r".

Here is the routine:

Please Login or Register  to view this content.

Hope that helps,

Daniel

[mohanvijay]

try this

Please Login or Register  to view this content.

[StormingDays]

Hi I think you can use the pastespecial transpose function.

Firstly select all the data you have.

Then use Ctrl+c
Then on a new sheet right click with your mouse > select paste special > select transpose.

Hope this helps