Insert left below name in PQ

[al72]

Hi,

When I extract employees timesheet data from our ERP,  I got something like this (fictive data):

In order to use the data, I have to insert cells below each employee name, left of each "activity" type. Then fill down the names and delete the empty rows and initial name rows in order to obtain this:

Its easy to do for data sets with a few employees but gets tedious when I got dozens of employees. Hence, I am looking for a clean way to do this with PQ, meaning the least steps possible. Column from example doensn't work since PQ can't make the difference between a name and an "activity" type. What is your take on this?

Thank in advance!

Al

[HotChilli · Accepted solution]

Add a custom column in Power Query saying something like:

if the3rdcolumn is blank/empty then the1stcolumn else null

then do a Fill Down on the new column

[al72]

Perfect solution! thank you so much 🙂

Al

[v-xinruzhu-msft]

Hi @al72 

It is glad that your problem has beed solved, and if the solution @HotChilli  offered helped you, you can consider to mark it as a solution for more user to refer to.

Best Regards!

Yolo Zhu