Forum Discussion
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 ...
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
Can you please post some sample data to present your query clearly? Try to post raw data and expected result or view.
Part of my reply looks like I sent it to myself underneath my initial reply to you. Please excuse my clumsiness