Q:

Terminology of two different tabular representations of aggregated data

think of a group of people aged from 21 to 35 years.
Then we can show the number of persons regarding gender and age groups 21-25, 26-30 and 31-35 in (at least) two different ways:
Type A

Type B

What I am curious about is what names are used to refer to those different types of table structures?
The practical relevance is that Excel can use Type A as a source for Pivot Tables but not Type B. Often though huge tables of type B are provided for statistics and I would like to google for 'How to turn Type B tables into Type A tables?'.

Terminology (summarized from answers):

Type A:

R: 'long data format'
'(melted) cross tab
Excel: 'flat(tened) data table'

Type B:

R: 'wide data format'
(traditional) cross tab

The search phrase for Excel/Pivot table would be 'how to flatten a cross table'.

A:

I'm not sure there is a universally accepted terminology.  At my work we call the first form a "melted cross tab", and the second form a "traditional cross tab".  In the world of R and the reshape or reshape2 package they are called "long" and "wide" data formats - see eg  this on R-bloggers.
And by the way if you are interested in converting one to another, I thoroughly recommend the melt() and acast() or dcast() functions in that R reshape2 environment.

