create blank query then in formula bar type
= {1..10}
next from menu (List Tools) To Table (Convert)
=Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
next Add Custom Column and type inside
{2..3}
Expand Custom to New Rows
= Table.ExpandListColumn(List23, "Custom")
add new custom column and type inside
[Column1]<>[Custom]
and next filter this column by TRUE
[#"A<>B"] = true
and add manually next two conditions
and ([Column1] = 2 or [Column1] = 3)
the last step is half manually all the rest is from menu
whole M:
solution was tailored to the OP
if you want something new , create new thread with detailed description
probably it will be like this
Bookmarks