Forum Discussion
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 rows stay with the Name row when sorted. Can someone give me directions how to do this?
I also copied this data into Word in case it can be more easily done there.
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
14 Replies
- 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
- 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
Website name: fake.com Website URL: http://fake.com/cleaner Login name: Login: email address removed for privacy reasons Password: fake Comment: --- Website name: fakealso.com Website URL: http://fakealso.com/cleaner Login name: Login: email address removed for privacy reasons Password: fakealso Comment: --- Website name: fake1.com Website URL: http://fake1.com/cleaner Login name: Login: email address removed for privacy reasons Password: fake1 Comment: --- - I don't know how to paste a piece of an Excel Sheet on here that looks like it should.
I desire each of the terms on the left side of the colon to be the column headings then the items to the right of the colons to be printed in rows correspondingly under each heading so that I can sort the column headings as desired and never lose the information critical about each website. I have a sample ready to paste if I only knew how.
Here is the data but it doesn't look like it is in a spreadsheet so I am posting it one line at a time:
Line 1:Website name Website URL Login name Login Password Comment
Line 2:fake http://fake.com/cleaner trying email address removed for privacy reasons madeup
Like 3:fakealso http://fakealso.com/cleaner trying email address removed for privacy reasons madeup2 fake data
Line 4:fake1 http://fake1.com/cleaner email address removed for privacy reasons madeup3
