Forum Discussion
Solved
Based on duplicated value, replace valus in another column
BATCH PO 1 5 # 5 2 4 3 6 Hello, I'm looking for the solution how to replace the value (#) in one column (BATCH) with the another value (1) from the same column based on d...
given that the AIB answer is correct, if you are better off with the PBI GUI, these are the steps you can follow to get the result:
order before column2 acsending, then column1 descending
finally, fill down column1
may be I incert it wrongly, but it doesn't make any difference to my tables..
given that the AIB answer is correct, if you are better off with the PBI GUI, these are the steps you can follow to get the result:
order before column2 acsending, then column1 descending
finally, fill down column1