Hi everyone,
I have three columns to in Excel file and I want the solution in Power Query.
Here are the complete details:
Column A Column B
U UU
U SIT
U QI
Z SIT
V SIT
V QI
V UU
Z2 SIT
Z UU
Z QI
Z SIT
Z2 QI
Z QI
Z2 SIT
Z2 SIT
Z QI
Z2 SIT
I need to remove only specific rows where Column A contains Z and Z2 and column B contains QI and UU.
In other words I just want to keep all vaue for column A except for Z and Z2 I need only SIT value in column B. Please help me to solve this issue in Power Query.
Thanks,
Rose
Bookmarks