Horizontal Data to Vertical

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!

In cell B2 of Combine Sheet you can try the formula:

Please Login or Register  to view this content.

and copy to right and down.

I was able to use both solutions to get the desired results!

I appreaciate the help

Thanks

This might work