Rows to Columns Transpose Error

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

Thank You for your quick reply! Yes, the goal behind this formula was to combine the values of rows and columns into two lists. For example
List Value Value II Value III
Apple +Red "Blue" {Green}
Banana +Yellow "Brown"

The goal would be for that to look like this:
List1 Color
Apple +Red
Apple "Blue"
Apple {Green}
Banana +Yellow
Banana "Brown"

However like in the sample I provided in the previous post after about 100 rows or so I run into errors where it no longer reflects what's in the list...

For example after 100 (or so rows) instead of having this..
Banana +Yellow
Banana "Brown"

It would start returning values like this:
Banana "Yellow"
Banana "Brown"