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.
| 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