combine 4 rows in to 1 all having unique values

Question

In this image you can see location is combination of different columns. The output i want needs to combine sizes S,M,L,XL to a single row and it should show only one location, Basically s,m,l,xl should be considered one. Also S is supposed to be on level 01,M on level 02, L on Level 03 & XL on 04)

Answer 1

You can use my DJoin function for this, taken from my project VBA.DJoin.

This also includes a demo file, and you'll see an example on how to list sizes:

using a multi-value field:

However, you probably don't have that. Instead, you'll have to create a table with the sizes and a sorting order, for example:

and include that in the query you use as source with DJoin.