I have a range of data in excel that is currently in 1 column, with sets of 32 rows.
If I transpose set of data (32 rows) it puts them into 32 columns, 1 row the page, this is what I want to achieve for the whole range of data.
But I need the sets (which are in 1 column) to be listed underneath each other.
I understand I need a VB script but I am kinda new to VB and its beyond me.
I have attached a copy of the dummy data - and how I want it to look in the long run.
Any advice/Help Appreacited.