Converting data in one column spanning three to four rows

Closed
rhinoramanan Posts 1 Registration date Friday July 21, 2017 Status Member Last seen July 21, 2017 - Updated on Jul 21, 2017 at 04:30 PM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Jul 21, 2017 at 06:06 PM
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

BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 149
Jul 21, 2017 at 05:33 PM
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
Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,238
Jul 21, 2017 at 05:42 PM
Well well, our illustrious bloke has returned. Delighted to have you back ! How was the food in the hospice?
0
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 149 > Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021
Jul 21, 2017 at 05:49 PM
The men in the white coats have only let me out for a short time.
0
Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,238 > BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021
Jul 21, 2017 at 05:58 PM
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
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 149
Jul 21, 2017 at 06:06 PM
I quite like thart idea. I must argue more often! (perhaps not!)
0