Merging cells based on the merging in another column and SUM them up

[diurpaneus]

Hi all,

I found this lovely community while googling for a solution to an issue I have. I want to kindly ask for your help with it.

I have this huge dataset, with 8000+ rows. It is basically an exported *.xlsx file from a database. For each client there is a specific ID and next to it there is a column with how many times that client was logged in. The database crates a separate row for each date - so after sorting according to Client_ID i had all client IDs grouped by number. Afterwards I found a VBA that enabled me the merge the cells with the same client ID - as in from Scenario 1 I am now in Scenario 2.

Now I am stuck - I want now to merge the cells on the colum Times_logged, based on the merging in column Client_ID AND to sum up the values. I found VBAs that merge cells based on the merging in other columns on this forum, but without summing the values up.


Could someone please help me out with some advice?

Thanks a lot in advance!!

 

[Kerryx]

Pivot Table ?

Book3
	A	B	C	D	E	F
1	Client	Times Log
2	32987	5		Row Labels	Sum of Times Log
3	32987	1		32987	6
4	32992	0		32992	0
5	32993	1		32993	6
6	32993	5		32998	9
7	32998	5		33001	27
8	32998	4		33002	4
9	33001	1		33004	4
10	33001	2		33007	0
11	33001	24		33011	2
12	33002	4		Grand Total	58
13	33004	4
14	33004	0
15	33007	0
16	33011	1
17	33011	1
Sheet1