Forum Discussion
Power Query: Splitting Table & Advance Grouping
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.
Hi Riny_van_Eekelen
Thank-you very much. I was able to come to the same conclusion that you provided in an earlier Power Query table. However I would like for the results (benefits ) to populate the column that is already created within the sample file I attached . Example Clark Kent is enrolled in Medical - CIGNA HMO... the column titled "Medical" should show Medical - CIGNA HMO for Clark Kent's Row.
Per the new file I attached, I am able to label and add Conditional Columns by each benefit (for time purposes I only listed Medical, Dental, Vision and Voluntary Hospital Care benefits and filtered out all others). Once this is done I could fill the conditional columns either "Up" or "Down", however this method does not work if there are numerous EE's who did not elect a particular benefit (Please review Voluntary Hospital Care - Rows 38 thru 57).
So in summary , I am wondering if there is a Table function within Power Query that could help populate unique rows with all the information described above.
Thank-you for all your help!
Warren