Sorting/Filtering Date

S

spgprivate

Hi again !

Another simply one I hope:

I have 2 columns of data

Country Band
UK A
GERMANY B
ITALY B
FRANCE D
SWEDEN D
DENMARK E

Is there a way I can show the data via colums ie

Band
A B C D E
UK Germany France Denmark
Italy Sweden


BR
Simo
 
F

Franz Verga

spgprivate said:
Hi again !

Another simply one I hope:

I have 2 columns of data

Country Band
UK A
GERMANY B
ITALY B
FRANCE D
SWEDEN D
DENMARK E

Is there a way I can show the data via colums ie

Band
A B C D E
UK Germany France Denmark
Italy Sweden


BR
Simon
Click to expand...

I'm not sure of what you're trying to do, because of the layout of data you
posted, but I think you could try with a pivot table...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top