Forum Discussion
Anonymous
3 years agoNot applicable
Power query
Need an output of each invoices with their shipper name and invoice value in power query
pcoley
6 months agoSuper User
1st create a custom column: if the column11(K) is null then take the value of the column1(A).
2nd select the created custom column and fill down
3rd filter the column2(B) keeping only the cells needed: as seen you must filter the cells with "IN" value.
Rename the columns as needed:
Column1(A)--> DocNumber;
Column2(B)-->TypeOfDoc;
Custom-->Amount
I hope this helps, if so, please mark as solution. Kudos are welcome
.