Transpose and count in a Pivot

[thed01]

Hi,
I just can't get this right and would really appreciate some help on how create a pivot like in the attached file. I want a pivot to sum upp the number appearencies in my data tables under the different years (years can appear more than once in column A )). Can it be it done or is it not posssible at all ?
Thank you for you help,

thed

[xlnitwit]

Hi,

You need to normalise your data. The simplest method is using a consolidation range pivot table- http://blog.contextures.com/archives...l-pivot-table/

[thed01]

Thank you for the link, I'll take a look at it and see if it also is what I did suspect, that the problem is that it's text in the "grid" and not numbers.