Converting data in one column spanning three to four rows

Closed
rhinoramanan Posts 1 Registration date Friday 21 July 2017 Status Member Last seen 21 July 2017 - 21 Jul 2017 à 14:30
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Moderator Last seen 30 September 2021 - 21 Jul 2017 à 18:06
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 response

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