I have a spreadsheet that I want to normalize so I can use it in an MS Access Database.
I have attached it but will explain what I have and then what I want.
This is how it exists:
Column A is the name of a volume table Header Name in Row 1 is VOL_TABLE
Column B is the name of a species Header name in Row 1 is SPECIES
Columns C through AI with Header name 10, 12, 14, 16, 18, 20......through to 74
Under each column header from row C -> AI is an actual volume. The header name represents the diameter of a tree.
What I want is this spreadsheet converted to 4 columns
COL A - HEADER VOL_TAB
COL B - HEADER SPECIES
COL C - HEADER DIAMETER (comes from the column header from C->AI
COL D - HEADER VOLUME (each individual volume)
Again I have attached the existing spreadsheet and would appreciate any help that you can provide with this. I do not know if this is easier done in Excel of Access. (I am using version 2007)
The spreadsheet has 2 pages. Page 1 is the current state. Page 2 is what I want.
Thanks in advance for help provided.