# 2 columns 4 rows -> 1 row 8 columns

I have two columns with 4 rows. I want to transpose them to one long row. I have tried:

=INDEX($A$1:B4,COLUMN(A1),1)

which works great for one column. I've not been able to work out how to get two columns into one row.

Basically my row should look like this : =A1|=B1|=A2|=B2|= A3|=B3|=A4|=B4

This will be need to be scaled. I have only these two columns, but many many rows. Effectively, I would love to choose the start and end point within these two columns, and the selection will then be split up across the row (see image).

Cheers

Your title would summarize to

I want to transpose them to one long rowYep, that was a typo. Cheers

You still haven't made your question clear and accurate. You describe your data "2 columns 4 rows" (which would be A1:B4), but then, describing how the resulting row should look like, write about A1:C(D...)2 - which also raises questions about if the "A1, A2, B1, B2, C1, C2 etc" was actually what you wanted to tell, or a typo again.

And writing about scaling, you don't describe how the data is scaled. Is the original data growing down (adding rows)? or to the right (adding columns)?

But you have only 2 columns with 4 rows - so I assume you want your row look like:

`=A1|=B1|=A2|=B2|=A3|=B3|=A4|=B4`

-- or --`=A1|=A2|=A3|=A4|=B1|=B2|=B3|=B4`

Apologies, and thank you for taking the time to help. Sometimes it's hard trying to get the wording right! I did make typos, but hopefully these are corrected now. Thanks again!

If you want your example to start in

`D1`

use:`=OFFSET($A$1;INT((COLUMN()-4)/2);MOD((COLUMN()-4);2);1;1)`

and drag 7 more cells to the right, but this works for 2 columns only and you have been talking about, which is still not clarified.scalingAmazing. Thank you. That was what I needed. As far as scaling, I mean only that I will be adding a heap more

but those two columns will only ever be two columns.rowsWould you have a moment to explain how that formula works? If my two columns do not start at A1 and B1, but at say E1 and F1, how might I adjust this formula?