I am trying to take a large amount of data that is listed vertically in groups of 16 lines seperated by 2 empty lines and have it shown horizontally into 16 columns.
I've tried the transpose function, which would work if I didn't have about 5500 lines of data. I've also tried a formula that kind of worked, but it put the verical data into one cell and not individual columns. Is there any way to do this? It seems like it should be simple but I can't get my desired result. I've attached the file, for reference.
Thanks for any help!