Two columns into one row

[alih]

I have some files I need to format. I have a list of coordinates that
are in two columns and I need to turn them into one row, keeping the
order
ie:
1 2
3 4
5 6
7 8
9 10 to 1 2 3 4 5 6 7 8 9 10
Is there anyway I can convert these two columns into rows without
cutting and pasting the data individually?

 

[oldchippy]

This will do what you want

=A1&" "&B1&" "&A2&" "&B2&" "&A3&" "&B3&" "&A4&" "&B4&" "&A5&" "&B5

note the space between the " "

 

[alih]

that works but the data is added to one cell. is there any way I can
get the data into separate cells as i need to be able to calculate
averages for each data point?

 

[oldchippy]

Is this what you are after?

Assuming data in in A1:B5
1. Select B1:B5
2. Right click > Cut
3. Select A6
4. Right click > Paste
5. Select A1:A10
6. Data > Sort > Ascending
With A1:A10 still selected
7. Right click > copy
8. Select E1
9. Right click > Paste Special > Transpose

Your data will now be in separate cells


If you wish to retain your original data in columns A & B
copy your data to column C and carry out the above based on col C &

 

[RagDyeR]

With your data in A1 to B5, try this:

=INDEX($A$1:$B$5,COLUMNS($A:B)/2,MOD(COLUMNS($A:A)-1,2)+1)

Enter anywhere and drag across.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


that works but the data is added to one cell. is there any way I can
get the data into separate cells as i need to be able to calculate
averages for each data point?