Forum Discussion
Convert a single row w/ employee and dependents row into individual rows for each person
Looking for some help in converting a data table. I'm thinking PowerQuery may be the solution. I need to convert the below tablet to where each person, employee and dependent, has their own row...
sbisa Yes! Definitely something for PQ. Can you show, based on the example data you provided how exactly the end result should look like? That is, how you would cut and past it manually to get the table you want.
Edit: Had a closer look at the data and thought that it could look like in the attached file.