Don't Even Know Where To Begin...

[ErikRP]

I have a table set up like this:

Client,ServiceDate,Service1,Service2...Service7,Msg01,Msg02...Msg20

The Service fields may or may not have values under each, depending on the number of services performed for the client, and they are always entered consecutively (i.e. Service1 will always have a value).

The Msg fields are similar to Services as they are filled in consecutively. They relate to all of the services in that record, so any values in the Msg fields are associated with each Service for that record.

Ultimately I need to see the information so it shows each service and each Msg that was associated to it.

So if a record was Service1=Repair, Service2=Clean and Service3=Grease and values in Msg01=4123, Msg02=1531 and Msg03=1234 I would expect to see:

Repair 4123
Repair 1531
Repair 1234
Clean 4123
Clean 1531
Clean 1234
Grease 4123
Grease 1531
Grease 1234

I don't know where to begin. I was thinking maybe a crosstab, or a pivot table but I am lost at this point. Any help would be much appreciated!!

 

[KenHigg]

I would recommend you read up on normalization -

Service1,Service2...Service7,Msg01,Msg02...Msg20 looks like bad juju

 

[ErikRP]

I agree, Ken, the starting table isn't in a nice format, but that is what I was given to work with. If there is a way to get the data into a better format which then makes the solution to my problem that much easier, by all means I'd appreciate the guidance.

I suppose I could always replicate the table 7 times (for each of the services) and take it from there, but we're talking a table of approximately 600,000 records...