Product List of customers split by country

[peddy]

Hi,

I have the following data

Country	Customer
UK	Customer 1
UK	Customer 2
Germany	Customer 3
Germany	Customer 4
Germany	Customer 5
Spain	Customer 6
Spain	Customer 7
Spain	Customer 8
Spain	Customer 9

I would like to display it as:

UK	Germany	Spain
Customer 1	Customer 3	Customer 6
Customer 2	Customer 4	Customer 7
	Customer 5	Customer 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:

UK	Germany	Spain
Customer 1
Customer 2
	Customer 3
	Customer 4
	Customer 5
		Customer 6
		Customer 7
		Customer 8
		Customer 9

Any help would be appreciated.

Thanks,

Peddy

[peddy]

Any ideas?

[atcodedog05]

Hi @peddy 

Here is how you can do it.

Workflow:

Hope this helps : )

[SoccerTil]

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