Hi,
This seems like a quick solution, I have tried modifying the macros of other similar problems individuals have had but my macros coding is not up to par.
In the data below I have a list of data that repeats the same format every 220 rows with data up to column AI, and this goes on for thousands of rows. Rather than individually selecting the range of 220rows and columns and transposing it horizontally, I would like a macros that goes through the list transposing up until the end.
I have attached a sample of the data. In the worksheet "What I Need" it shows what I would like to do with this data.
Thank you,
Haseeb
Bookmarks