# 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?'.

1. Type A:

• R: 'long data format'
• '(melted) cross tab
• Excel: 'flat(tened) data table'
2. Type B:

• R: 'wide data format'
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.