Change records

V

Vincdc

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!
 
J

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"
 
V

Vincdc

Thanks for your quick response!


Jay said:
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"
 
Top