Merging Multiple Rows into One Row

[micahjday]

I currently have a project of about 11,000 rows that essentially
should be about 3,300 rows.

the data is looks something like this:

Company Mon Tues Wed
ABC 24
ABC 32
ABC 16


I would like it to look like this:

Company Mon Tues Wed
ABC 24 32 16

Is there an easy way to merge the unneeded cells and make it one row
instead of three for the same company?

Thanks

 

[Ed Bennett]

I currently have a project of about 11,000 rows that essentially
should be about 3,300 rows.

Is there an easy way to merge the unneeded cells and make it one row
instead of three for the same company?

Is this in a Publisher file or in a database format of some kind?

 

[Brucels]

Sounds like a question for either the Access or Excel discussion group.

Bruce

 

[Oceaneer]

You need to create a Crosstab query in Access to 'pivot' the data such that
the days of the week become columns (fields) and the totals become the values
for each of these fields. If the data is a simple and repetitive as your
example, it will work great. The trick is having Mon, Tues, etc. stored in
one of your fields. The values of that field will become columns. Now,
whether Publisher will read in a Crosstab query is a different matter...