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 this link 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

Lorenzo

Silver Contributor

Jul 18, 2022

YorkGardener

Sorry but this won't work...

1/ You marked one of you reply as Best response. This is misleading as the case is obviously not solved

2/ In your last reply you talk about line1 through line4 while initially you said you had 5 and in your reply to Harun24HR we see 6 rows/lines (Comment) before possible empty/blank rows + those possible empty/blank rows seem not to be blank. Still in reply to Harun24HR I see "---"

3/ Now you ask the output on a single row (not a problem)

Please understand nobody can adapt the query (or use another method) without a clear understanding of what must the removed first (i.e. blank rows) and how many rows exist in each "block" after that

If you carefuly follow the instructions on this page you should be able to share your sample workbook (Share a file or folder) and reply here with the shared link (Get a link for sharing)

Thanks

YorkGardener

Copper Contributor

Jul 19, 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.

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.
Lorenzo
Silver Contributor
Jul 20, 2022
Hi YorkGardener

Worst case scenario click this link 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