Converting data in one column spanning three to four rows

Closed
Report
Posts
1
Registration date
Friday July 21, 2017
Status
Member
Last seen
July 21, 2017
-
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
dear sir
i have an address book over 500 addresses in column A.
i am not able to index the book alphabetically
i need to shift the data in a2 of the column A to the b1 and a3 to c1 and a4 to d1
i need to do this for all the 500 addresses so that i can sort alphabetically based on column A which will have only the names left
regards
ram

1 reply

Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
146
Hi.

Try this ...

Select the range of data you want to rearrange.
Press Ctrl and X at the same time (the cells disapear).
Right-click the first cell where you want to paste the data.
Choose "Transpose" under the Paste Heading (the data reapears in the way you want it).
Save your Worksheet.

I hope this helps.
0
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,365
Well well, our illustrious bloke has returned. Delighted to have you back ! How was the food in the hospice?
0
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
146 >
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021

The men in the white coats have only let me out for a short time.
0
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,365 >
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021

Oh well! I guess that they know what they are doing, who would want to argue with the white coats and risk getting another enema and be forced to swallow pint of prune juice?

Good luck and be brave. I will send you some oranges.

God save the Queen !
0
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
146
I quite like thart idea. I must argue more often! (perhaps not!)
0