Forum Discussion

Retiredtrialjudge's avatar
Retiredtrialjudge
Copper Contributor
Oct 18, 2022

Sorting with following items

There is probably an easy way to do this, but I can't find/figure it out.   I want to go shopping to the Grocers, Wal Mart, and the Pharmacy.   I have several items to get at each place.   So I e...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 18, 2022

Retiredtrialjudge 

 

Another option if you run Excel 365. With your data in Table named ShoppingList (as previously shared):

 

=LET(
  FillShop, SCAN(,ShoppingList[Shop],
    LAMBDA(seed,shop, IF(shop <> "", shop, seed))
  ),
  StackData, HSTACK(FillShop, IF(ShoppingList <> "", ShoppingList, "")),
  DROP(SORT(StackData, 1),,1)
)

 

In attached file next to the Power Query option in sheet SORTED

Resources