Google Sheets: Join Columns & Rows into one Text String

[p_s]

Item	Qty
Apple	45
Basketball	24
Tennis Racket
Orange	64
Women's Shoes
T-shirts	67
Pants	11
Cauliflower	35
Green Beans	125

Desired Output:

45 Apple, 24 Basketball, 64 Orange, 67 T-shirts, 11 Pants, 35 Cauliflower, 125 Green Beans

Preferably in one cell without referencing each cell individually, so that it can be expanded if someone adds more rows. The columns may not be adjacent. Skips the row where the qty is 0/"" for the columns selected.

Can someone help me with this please.

 

[RoryA]

Something like this should work:

=join(",",filter(B2:B&" "&A2:A,B2:B>0))

 

[p_s]

Something like this should work:

=join(",",filter(B2:B&" "&A2:A,B2:B>0))

Perfect, thanks!