Alternative to Table. SelectRows on Power Query
- Thread starter vsolano
- Start date
p45cal
Well-Known Member
Presumably you have a column or columns which determine whether you want the row or not.
You could try either filtering on that/those column(s), or Group By, or a Merge. [note re:
More details required, ideally a workbook with a realistic representation of what you're trying to do.
You could try either filtering on that/those column(s), or Group By, or a Merge. [note re:
Group By will allow you to aggregate at the same time as 'selecting' the rows, whereas Merging won't]
More details required, ideally a workbook with a realistic representation of what you're trying to do.
Last edited:
p45cal
Well-Known Member
Plain filtering on Hdr2 would seem to be the easiest [edit: oops, just realised this is SelectRows!], otherwise, starting with a table:
You could Group By Hdr2, and your table is shown below:
Here, you could filter Hdr2 for TRUE before expanding the grp column.
Instead, using Merge, set up a second table and merge:
leaving you with:
You could Group By Hdr2, and your table is shown below:
Here, you could filter Hdr2 for TRUE before expanding the grp column.
Instead, using Merge, set up a second table and merge:
leaving you with:
Attachments
Last edited: