Hello excel forum users. I am looking for a way to transpose a large amount of data into a data panel for stats analysis. I've been doing some of it manually but it is very tedious, and I am expecting to receive much more data in the future which makes me feel rather desperate. I've tried recording a macro but that was equally tedious and won't work for data thats not in exactly the same place as where I recorded it.
I have attached an excel file with the data, with the second sheet in how I want it to end up. My plight is very similar to what I found in this thread, but I can't get that macro to work. I am, like the TP of that thread, a VBA illiterate and I haven't gone beyond recording macro's in more simple situations.
I would very much appreciate help in a macro that can add every block into its own individual row in the panel sheet. Thanks in advance.
Bookmarks