alphabetizing clustered rows of data

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
  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
  - YorkGardener
    Copper Contributor
    Jul 18, 2022
    I didn't mention the blank/empty rows but they did show up in my initial post:
    Harun24HR
    
    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:
    
    ---
    0 Likes
    Success! This post is now a best response.
    
    best response confirmed by YorkGardener
    YorkGardener
    YorkGardener replied to YorkGardener
    ‎Jul 17 2022 08:09 PM
    
    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
    
    I still don't understand how to post a copy of the spreadsheet. I did save my little sample I created using your Power Querry to the cloud. But it doesn't copy from there any different than the spreadsheet I saved to my computer. I am totally missing a very simple something. I think that I am probably supposed to be sharing my sample file but I don't know how to do that here.
    
    Please note that I am desiring my eventual spreadsheet data to have each entry on one row.
    Gracious this would be so much easier to explain if I knew how to attach a spreadsheet file.
    
    I do thank you so, so much for your assistance thus far.

Forum Discussion

Resources