Product List of customers split by country

Question

Hi,

I have the following data

CountryCustomerUKCustomer 1UKCustomer 2GermanyCustomer 3GermanyCustomer 4GermanyCustomer 5SpainCustomer 6SpainCustomer 7SpainCustomer 8SpainCustomer 9

I would like to display it as:

UKGermanySpainCustomer 1Customer 3Customer 6Customer 2Customer 4Customer 7 Customer 5Customer 8  Customer 9

Each list needs to be alphabetical order. It also needs to be dynamic, so it there are additional countries it can still work.

I've almost organised it, but I can't get each list to start at from the 1st row. It's more like this:

UKGermanySpainCustomer 1  Customer 2   Customer 3  Customer 4  Customer 5   Customer 6  Customer 7  Customer 8  Customer 9

Any help would be appreciated.

Thanks,

Peddy

SoccerTil · Answer

Multi Row formulas require work, Tile doesn't. So here's another solution that is much the same but with less coding.

splitJoin.yxmd

atcodedog05 · Answer

Hi @peddy

Here is how you can do it.

Workflow:

Hope this helps : )

customer.yxmd

peddy · Answer

Any ideas?