Hi,
in column A I have tel numbers, in column B I have cities to which they belong.
There are more than 10000 entries.
I would like to have cities sorted in on row, and below each city a list of all numbers that belong to it.
I have tried sorting, pivoting and many other things but without success.
Thanks in advance for any suggestion.
in column A I have tel numbers, in column B I have cities to which they belong.
There are more than 10000 entries.
I would like to have cities sorted in on row, and below each city a list of all numbers that belong to it.
I have tried sorting, pivoting and many other things but without success.
Thanks in advance for any suggestion.