Change records

[Guest]

Hello:
I have some data in the following format:
LA
A
B
C
D
....
Is there any easy way to change the format into:
LA A B C D
Thanks in advance!

 

[Jay]

I have some data in the following format:

LA
A
B
C
D
...
Is there any easy way to change the format into:
LA A B C D

1. Select the data.

2. Use "Edit >> Copy"

3. Select an empty cell someplace where you want the result to start.

4. Use "Edit >> Past special" and choose "Transpose"

5. Click "OK"

 

[Guest]

Thanks for your quick response!

1. Select the data.

2. Use "Edit >> Copy"

3. Select an empty cell someplace where you want the result to start.

4. Use "Edit >> Past special" and choose "Transpose"

5. Click "OK"