I have several historic data sets that I would like to normalize to a common structure.
I would like to convert this:date |area | color | Dodge | BMW | Delorean | Ford
12/2/2012 | London | blue | 2 | 3 | 1 | 6
12/3/2012 | Tokyo | green | 1 | 5 | 2 | 1
12/3/2012 | Juneau | white | 0 | 1 | 1 | 9
to this:
date | area | color | quantity | make
12/2/2012 | London | blue | 2 | Dodge
12/2/2012 | London | blue | 3 | BMW
12/2/2012 | London | blue | 1 | Delorean
12/2/2012 | London | blue | 6 | Ford
12/3/2012 | Tokyo | green | 1 | Dodge
12/3/2012 | Tokyo | green | 5 | BMW
12/3/2012 | Tokyo | green | 2 | Delorean
12/3/2012 | Tokyo | green | 1 | Ford
12/3/2012 | Juneau | white | 0 | Dodge
12/3/2012 | Juneau | white | 1 | BMW
12/3/2012 | Juneau | white | 1 | Delorean
12/3/2012 | Juneau | white | 9 | Ford
Is this something that pivot table can handle?
I confess to being a bit lost regarding how to frame this problem...even though it seems so simple!
TIA for ideas and suggestions.
Bookmarks