Consolidating Rows

[Guest]

Hi All,

I have three rows of data I was hoping to consolidate into one row. My data
set looks something like this...

colA colB colC colD colD
Joe 4 14 12 2
Joe 2 0 0 1
Joe 4 5 2 5
Bob 4 3 2 4
Bob 5 6 34 5
Tim 12 43 45 5


What I would like to do is create one row summing the values int he column
for each individual so that it looks something like this....

colA colB colC colD colD
Joe 10 19 14 8
Bob 9 9 36 9
Tim 12 43 45 5

Thanks!

 

[Dave Peterson]

Maybe just adding headers, sorting your data and applying data|subtotals would
be enough.

You can use the outlining symbols at the left to hide the details and see
nothing but the subtotals.

 

[Guest]

Try a pivot table (PT) option ?
Takes only a few clicks and drags n drops to get there in under 60 sec ..

Insert col labels in row1, eg: Lab1, Lab2 ... Lab5
(Lab1 = Names col)

Select any cell within the table
Click Data > Pivot table & PT chart report
Click Next > Next
In step3, click Layout,
Drag n drop Lab1 in ROW
Drag n drop Lab2 in DATA
(It'll appear as Sum of Lab2)
Repeat step for Lab2 for Lab3 to Lab5 (drop one below the other)
Click Finish

The PT will be created in a new sheet to the left. In the PT sheet, the PT
will appear "vertical". No problem. Just drag "Data" and drop it over "Total"
to return the desired horizontal layout ..