Forum Discussion

YorkGardener's avatar
YorkGardener
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's avatar
    Lorenzo
    Jul 20, 2022

    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

YorkGardener's avatar
YorkGardener
Copper Contributor
Jul 18, 2022
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.
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 18, 2022

    YorkGardener 

    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

    • YorkGardener's avatar
      YorkGardener
      Copper Contributor
      Jul 18, 2022
      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
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jul 18, 2022

        YorkGardener 

         

        In your initial post you didn't talk about blank/empty rows. So please enter or copy/paste in the blue table (In) I shared a respresentative actual sample (can be 100s or rows no problem), save the file then share it with i.e. https://www.bing.com/ck/a?!&&p=e9e1d8b500ba8fd9606805e9adb83846ead4e00caa21707d06bcf978431c02f8JmltdHM9MTY1ODE0MDMzNCZpZ3VpZD0xNTAxYmM3Mi01MzA0LTQzNzktYTU4OC1lM2QzMTIwMGU3MDAmaW5zaWQ9NTE2Mw&ptn=3&fclid=e39222d8-0684-11ed-9798-01fb495f0191&u=a1aHR0cHM6Ly9zdXBwb3J0Lm1pY3Jvc29mdC5jb20vZW4tdXMvb2ZmaWNlL3NoYXJlLW9uZWRyaXZlLWZpbGVzLWFuZC1mb2xkZXJzLTlmY2MyZjdkLWRlMGMtNGNlYy05M2IwLWE4MjAyNDgwMGMwNw&ntb=1, Google Drive...

         

        I'll see if it's consistent enough to revise the shared Power Query code

Resources