Forum Discussion

al72's avatar
al72
New Member
2 years ago
Solved

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...
  • HotChilli's avatar
    2 years ago

    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