I have the following data.

Description Description
Item 900 900
Item 300 400

And i need to transpose this into a tabular format.

Like this:

Item Description Quantity.

I found the following formula
=INDIRECT(ADDRESS(TRUNC((ROW()-2)/3)+2,1,,,"Sheet1"))
=INDIRECT(ADDRESS(1,MOD(ROW()-2,3)+2,,,"Sheet1"))
=INDIRECT(ADDRESS(TRUNC((ROW()-2)/3)+2,MOD(ROW()-2,3)+2,,,"Sheet1")).

The problem is that i have more that 1 million rows (around 10 mil) that a worksheet can hold.

Is there another way i could do it?

Thank you