Forum Discussion
al72
2 years agoNew Member
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...
- 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
HotChilli
2 years agoCommunity Champion
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