Forum Discussion
alphabetizing clustered rows of data
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
- I don't understand your reply. Are you trying to show me how to show an Excel example on this site? I have no idea how I would achieve a Power Query but it looks like what I need to be able to do if I only knew how.
The picture was only an illustratiion to show what the Input is (simulates your data) and what we get as Output after applying a Power Query "script" (not VBA/macro), assuming you run at least Excel 2016 on Windows
To experiment it:
- Download the file attached to my previous reply
- Copy/Paste some of your data in the blue table (In)
- Right-click in the green table (Out) > Refresh
- I think that this will work to at least get me part of the way to where I want to be, perhaps all the way, but I will need to expand it so that I can enter at least a hundred rows of data into the left-hand column to test it out since there are so very many blank rows in my original data. How do I expand the Power Query? I would post my example like you did (as a spreadsheet) if I knew how. Could you tell me how to post a spreadsheet as a spreadsheet also? By the way, I run Outlook365
