Data Manipulation

[IanT]

Hi

I have data which looks like this:

Type: Band1: Band2: Band3:
Chair 10.00 15.00 20.00
Stall 20.00 25.00 30.00

I would like to arrange the data to look like:

Type: Price:
Chair 10.00
Chair 15.00
Chair 20.00
Stall 20.00
Stall 25.00
Stall 30.00

Is this possible!

Thanks in advance!

 

[maxmangion]

you need to normalise your data. Search the forum for normalisation/normalization, there are several threads discussing the issue.

 

[Shadez]

you need to normalise your data. Search the forum for normalisation/normalization, there are several threads discussing the issue.

that all depends on what the data is\how it is stored, and what he is about to do with it.

So IanT, yes its is possible but in order to help we need to know how is the data stored and where is it going?

 

[IanT]

Hi Shadez

The original data is in Excel. I have attached example of data imported into Access.