combing cells with same data

  • Thread starter Thread starter inprogress
  • Start date Start date
I

inprogress

i did a search but nothing that i was looking for came up. maybe i wasnt
searching the right terms. here's my problem.

i have a list of data

......a.....b....c....d.....e...f
1 john usa 876 675 454 345
2 bob china 34 545 034 000
3 bob china 03 000 0006 0002


i want to combine row 2 and 3 so it looks like this
bob china 37 545 40 2

it would be nice if the new added row replaced the previous row 2 and
3

i have a whole list of data.. about 3000 rows

any help would be appreciated.
 
Perhaps try a pivot table ?
Only a few clicks will get us there

Assume the source data (with a header row inserted / added on)
is in Sheet1, A1:F4

Lab1 Lab2 Lab3 Lab4 Lab5 Lab6
john usa 876 675 454 345
bob china 34 545 34 0
bob china 3 0 6 2

(All figures are assumed real numbers)

Select A1:F4, click Data > Pivot Table Report
Click Next > Next

In step 3 of the wizard:
Drag Lab1 and drop within the ROW area
Drag Lab2 and drop within the ROW area (below Lab1)

Drag Lab3 and drop within the DATA area
(It'll appear as "Sum of Lab3")
Repeat for Lab4 to Lab6 (one below the other)

Click Finish

The pivot will be created in a new sheet to the left

Go to the pivot sheet
Double-click on Lab1, set the Subtotals to "None" > OK
Drag "Data" and drop on D1

You should get a table which looks like this:

--------------- Data
Lab1 Lab2 SLab3 SLab4 SLab5 SLab6
bob china 37 545 40 2
john usa 876 675 454 345
Grand Total 913 1220 494 347
 
Back
Top