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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top