combing cells with same data

Try looking at the Data->SubTotals feature of Excel

--
Cheers
Nigel



"inprogress" <inprogress.1tj8ii_1123650366.1914@excelforum-nospam.com> wrote
in message news:inprogress.1tj8ii_1123650366.1914@excelforum-nospam.com...
>
> 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.
>
>
> --
> inprogress
> ------------------------------------------------------------------------
> inprogress's Profile:
http://www.excelforum.com/member.php...o&userid=26117
> View this thread: http://www.excelforum.com/showthread...hreadid=394465
>

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

--
Note: SLab3 actually appears as "Sum of Lab3", etc
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"inprogress" <inprogress.1tj8ii_1123650366.1914@excelforum-nospam.com> wrote
in message news:inprogress.1tj8ii_1123650366.1914@excelforum-nospam.com...
>
> 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.
>
>
> --
> inprogress
> ------------------------------------------------------------------------
> inprogress's Profile:
http://www.excelforum.com/member.php...o&userid=26117
> View this thread: http://www.excelforum.com/showthread...hreadid=394465
>