Rearrange Data

[simon081286]

Hi,

Does anyone know if/how you can rearrange data from multiple cells in row 1 so that they are all in column A and in multiple rows? i.e.

I have:

A B C D
1 Apple Banana Orange Pear

but need:

A
1 Apple
2 Banana
3 Orange
4 Pear

Is there a simple tool/formula to achieve this?

Thanks in advance!

Simon

 

[VoG]

Copy the row.

Select an empty cell in column A.

Edit > Paste Special, check Transpose and click OK.

 

[Aladin Akyurek]

Hi,

Does anyone know if/how you can rearrange data from multiple cells in row 1 so that they are all in column A and in multiple rows? i.e.

I have:

A B C D
1 Apple Banana Orange Pear

but need:

A
1 Apple
2 Banana
3 Orange
4 Pear

Is there a simple tool/formula to achieve this?

Thanks in advance!

Simon

Copy A1:D1.

Select A2 and run Paste Special | Transpose.

Or:

A2, copy down:

=INDEX($A$1:$D$1,ROWS($A$2:A2))