Forum Discussion

Copper Contributor

Jul 17, 2022

Solved

alphabetizing clustered rows of data

I have five rows of data such as: Name Title Telephone Address Company These 5 rows repeat over and over in one column. I need to sort them alphabetically by Name but have the 4 accompanying ...

excel

office 365

Lorenzo
Jul 20, 2022
Hi YorkGardener

Worst case scenario click https://1drv.ms/x/s!AsuqEFbTJNgcgaMCDSjsnFxni_fSZA?e=GXdm4y that will open Excel online. I shared that file so you can copy/paste your values only . Don't go to fast, there are couple of things you must pay attention to:

1 - When the file opens in Excel Online it's in Viewing mode. You must click on Viewing and select Editing. Then you can copy/paste your data

2 - Once your data are in the sheet, wait a few seconds until you see at the top left Saved to OneDrive

after that just close your web browser window & post a message here to say your data are available online

YorkGardener

Copper Contributor

Jul 20, 2022

L z Thank you for hanging in there with me. I didn't realize that I marked a reply as Best response. I am learning how to communicate here mostly by doing it wrong and having the correct way shown to me. You are being so thoughtful to do this for me.

The "---" I knew that I could eliminate and therefore considered it blank since it wasn't data I needed nor would be using. I suppose blank was a poor term to use.

As I had no idea of what I was asking for when asked, I didn't know what was important information and what wasn't. I think it would have been so much easier had I known how to do the cloud sharing at the beginning. I have to put this on a back burner for a few days but I will explore the page you indicated and then post my data here and hope that you will then offer me assistance again.
I didn't realize that I ever did anything other than post replies. I certainly thank you for your assistance and patience.

Lorenzo

Silver Contributor

Jul 20, 2022

Hi YorkGardener

Worst case scenario click https://1drv.ms/x/s!AsuqEFbTJNgcgaMCDSjsnFxni_fSZA?e=GXdm4y that will open Excel online. I shared that file so you can copy/paste your values only . Don't go to fast, there are couple of things you must pay attention to:

1 - When the file opens in Excel Online it's in Viewing mode. You must click on Viewing and select Editing. Then you can copy/paste your data

2 - Once your data are in the sheet, wait a few seconds until you see at the top left Saved to OneDrive

after that just close your web browser window & post a message here to say your data are available online

YorkGardener
Copper Contributor
Jul 20, 2022
I tried to remove the best response check but I don't think it did it. I will be trying to do this later this week. Again my sincere thanks for the help you have been thus far.