Using Power Query to restructure Microsoft Excel data requires no expressions or functions. You add a column for the combined values and then group if you want to combine those values further into ...

If the natural data can't support the sorting and filtering requirements, you might need to add an index column and sort by it.