Forum Discussion
Insert left below name in PQ
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
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
3 Replies
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
