Ms Access Data Normalizing

[mr moe]

Hi haven't been here in years. I actually have a question which might be complicated. So i'm importing to access an excel file. The excel file has 5 columns, each column has a header with values. For example.

Truck Van Small Car Large Car
54 5454 6464 1111
654 45454 56 654 5454
66 222 54654 444
15 555 45454 555

Trying to convert this into like

type count
Truck 54
Truck 654
Truck 66
Truck 15
Van 5454
Van 45454
Van 222
Van 555
Small Car 6464
Small Car 54545
Small Car 54654
Small Car 45454
Large Car 1111
Large Car 5454
Large Car 444
Large Car 555

hope somone can get me started. Thanks alot.

 

[stopher]

Import the data to a temporary table in Access. Then write 5 (or is it 4) append queries to copy each column to the target table.

 

[mr moe]

Its almost like i'm trying to Un-Transform the data. I can append the data one at a time like you said but how about appending the row header name, like the car type. I can send an excle file if needed to look at.

 

[Minty]

You need this http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/