VBA to transpose data

[JoelBrown]

Hi there,

I posted a similar question a few years ago which proved successful but cannot find the macro script so will post again.

I have multiple rows of data which has been taken from a completed pdf and have been merged into a spreadsheet as a csv.

I have saved the spreadsheet as a .xslm file and require a macro to transpose the data into a set layout.

I require the first three cells of the row to remain where they are then the next 11 cells to remain as they are, then after this every 11 cells I require to move under the first set of 11 cells.

I appreciate this might sound difficult to understand so I have provided a dropbox link to the two spreadsheets as an example. The first shows how the data is extracted as a csv and the second shows how I require the data.

If possible I would like the first three cells to be duplicated all the way down for that property (if it can only remain on the first line then that is fine).

There will be more than one line of data, more like 50 at a time so I require the macro to complete the process for all the data in one hit.

Any help would be much appreciated.

Many thanks,
Joel

https://www.dropbox.com/sh/2qyh5y8f91hajk5/AABPvkj0D2ssP7OLZNzb6yJFa?dl=0

 

[Fluff]

Is this the code? https://www.mrexcel.com/forum/excel-questions/825664-transposing-data.html#post4028253

 

[JoelBrown]

Hi Fluff,

Thanks for the response.

This is the thread that had macro I had in mind but due to the range of cells being different and also this time I require an extra things to happen.

Are you able to have a look at the spreadsheets I put into the dropbox and offer any help?

thanks,

Joel