Can someone please help me with Excel???

[JOHNNYxCASH]

Is the following possible and how I do it?? Thanks...

I have a spreadsheet with data in cells A1 - A404

I want the data from...

A1 to appear in B1
A2 to appear in C1
A3 to appear in D1
A4 to appear in E1
A5 to appear in B2
A6 to appear in C2
A7 to appear in D2
A8 to appear in E2

and so on so that it looks like this

A B C D
E F G H

instead of

A
B
C
D
E
F
G
H

Is there a formula I can use? If anyone can help I would really appreciate it!

Thanks.

[ACtheTROLL]

just use =
so the first one
in b1 type
=a1
in c1
=a2

alternatively
type = and then click on the cell you want

[JOHNNYxCASH]

Thanks for your answer matey - I know this is one way of doing it but it's going to be very time consuming as I have 404 rows of data so I was hoping there might be a formula i could use instead?

[THECORBYLOON]

If E1=A4 and E2=A8, will E3=A12 and so on? If so, one way is to write A1 in B1, A2 in C1, A3 in D1 and A4 in E1. On the line below, write A5 in B2 A6 in C2, A7 in D2, A8 in B in E2.
Once you�ve done that, highlight the area containing those eight cells so that you see a wee �+� in the bottom right �hand corner of cell E2 and atuofill the rows below.

When that�s been done, select the larger area and choose the find and replace function. Then replace �A� wi �=A� and that should do what you were wanting.

No doubt there�s an easier way but ma way seems to work.

[ChuckFickens]

have you thought about just reformatting the spreadsheet so the data is in the correct cell to start with?

[ACtheTROLL]

lol

cracked it!
I was almost ready to say only data not with formulas ..

if we assume the data is in column a
in col B1 enter =$a1
(absolute column with varible row)

drag the fformula down to the bottom if the data so col B reflects all of A

select the range to become row1 and copy
select the first cell of the row and paste special
tick the "transpose" option
and OK

repeat with the next range and the next.

done!

[JOHNNYxCASH]

Thanks to all you peeps for helping - I couldn't get THECORBYLOON's to work but that may have been my fault rather than yours! ACtheTROLL my mate used part of your suggestion and added in a 'macro' and now it works automatically at the click of a button!

Thanks again for all your help.