Quizzes & Puzzles2 mins ago
Can someone please help me with Excel???
6 Answers
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.
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.
Answers
Best Answer
No best answer has yet been selected by JOHNNYxCASH. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.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.
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.
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!
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!