I need to know an easy way to combine multiple rows of data into a single row
of data for a labor report that I'm working on.
My problem is that I have a report that generates 12 columns. I add an
additional 12 columns to this spreadsheet, one for each month. The first 9
columns contain specific data for each employee, the next 2 columns contain
data that is specific to the amount of labor each individual works in a given
month. The given month is the 12th column. So if the person charged to the
project 4 different months, I get 4 rows entries in the table.

I'd like to compress these 4 lines down into one, and so on for all
employees in the report. The first 9 columns contain duplicate data, since
the employee data is the same. For each of the month columns I've done a
test on the 12th column to tell what month the individual charged labor to,
and populated the labor amount from column 11 into the appropriate month
column. Now if I subtotal each month, I can see one line, by employee and
the amount of labor for each month on one line. I'd like to not have to
subtotal and see this same report with all the data from the first 9 columns
as well.

Any help would be greatly appreiciated. Thanks, JLM

In one of the columns there is data that I'd like entered into about 10
fields (columns), for each row there maybe 5 occurances of the first 9 pieces
of data. I want the the
10th column put in a new column (month)