abaker77
New Member
- Joined
- Oct 11, 2011
- Messages
- 18
- Office Version
- 365
Hello,
I have what I think can be solved with a simple Power Query feature - "Pivot Column", but I can't get it to work.
The image above should explain exactly what I'm hoping for.
Cols G-H contain my original table - with 2 columns: account # and name; these may be in any order and sequence.
What I need is cols J-O which lists the unique account #'s across the top and every name that belongs to the account #, beneath it.
This is an ever-changing list to once the table is updated, I'm hoping I can simply hit Ctrl-Alt-F5 to Refresh and re-generate my desired result.
I think 'Pivot Column' should work but I can't figure out how to do it.
Surely there are geniuses out there (?); I'd be so grateful if someone could let me know.
THANK YOU SO MUCH!
I have what I think can be solved with a simple Power Query feature - "Pivot Column", but I can't get it to work.
The image above should explain exactly what I'm hoping for.
Cols G-H contain my original table - with 2 columns: account # and name; these may be in any order and sequence.
What I need is cols J-O which lists the unique account #'s across the top and every name that belongs to the account #, beneath it.
This is an ever-changing list to once the table is updated, I'm hoping I can simply hit Ctrl-Alt-F5 to Refresh and re-generate my desired result.
I think 'Pivot Column' should work but I can't figure out how to do it.
Surely there are geniuses out there (?); I'd be so grateful if someone could let me know.
THANK YOU SO MUCH!