maybe this
Column A |
Column B |
|
Column A |
Column B |
U |
UU |
|
U |
UU |
U |
SIT |
|
U |
SIT |
U |
QI |
|
U |
QI |
Z |
SIT |
|
Z |
SIT |
V |
SIT |
|
V |
SIT |
V |
QI |
|
V |
QI |
V |
UU |
|
V |
UU |
Z2 |
SIT |
|
Z2 |
SIT |
Z |
UU |
|
Z |
SIT |
Z |
QI |
|
Z2 |
SIT |
Z |
SIT |
|
Z2 |
SIT |
Z2 |
QI |
|
Z2 |
SIT |
Z |
QI |
|
|
|
Z2 |
SIT |
|
|
|
Z2 |
SIT |
|
|
|
Z |
QI |
|
|
|
Z2 |
SIT |
|
|
|
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Merge = Table.CombineColumns(Source,{"Column A", "Column B"},Combiner.CombineTextByDelimiter("=", QuoteStyle.None),"Merged"),
TSR = Table.SelectRows(Merge, each ([Merged] <> "Z2=QI" and [Merged] <> "Z=QI" and [Merged] <> "Z=UU")),
Split = Table.SplitColumn(TSR, "Merged", Splitter.SplitTextByDelimiter("=", QuoteStyle.Csv), Table.ColumnNames(Source))
in
Split
Bookmarks