We help IT Professionals succeed at work.
Get Started

Need help reformatting a spredsheet

335 Views
Last Modified: 2012-08-14
Hello

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.

PBLack

 voltable.xlsx
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE