Forum Discussion
Power Query: Splitting Table & Advance Grouping
Hi - I have a table that has multiple rows for every employees associated with individual ID Numbers. Each Employee is enrolled in a number of benefits (Medical, Dental, Vision, etc.). Each benefi...
WARJAMAND Not convinced I did it the most effective way, but the attached workbook "merges" all rows per ID into a single row, by grouping and adding a series of columns, before expanding and cleaning up a bit. See if this method works on your real data.