Rows to Columns Transpose Error

[Excell1677]

Hello,

I ran into a problem while combining multiple rows and columns. The goal behind this is I am merging multiple columns or rows of data into two lists. I used an Index, Match array function but after a certain amount of rows I run into errors. I enclosed a sample of the problem.

Thank you for your time