Transform 1000rowsx50columns table into 2columns

[deemo]

Am working with a spreadsheet of about 1000 rows and 50 columns which I need to transform into 2 columns and as many rows as needed.

I have attached a simplified example of a 3x3 spreadsheet so you can see what I mean.

I have already managed to get my result using Filtering and some copy and paste but I am struggling to now fully automate the solution. Any help appreciated

[DonkeyOte]

See if the attached helps - based loosely on your example:

[mdbct]

Try this:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

One way using VBA.
Name your table "Table", and name the cell where you want your output to start "Start", then use the following procedure:

Please Login or Register  to view this content.

Rgds

[deemo]

Hey this is great - thanks to all of you. Works perfectly!