Clubbing data values

[kishore k]

hi,

i have data in sheet 1 as per below data, and need a formula to get the data clubbed with similar data and get the output as per sheet 2 in columns A,B & C as per data below

Sheet 1

A	B	C
41001	MAY-19	350
41001	MAY-19	200
51000	JUN-19	500
51000	JUN-19	600
41011	APR-19	700

<tbody>
</tbody>

Sheet 2

A	B	C
41001	550	MAY-19
51000	1100	JUN-19
41011	700	APR-19

<tbody>
</tbody>

 

[alansidman]

Create a Pivot Table. Put A and B in the Rows. C in the Values

 

[kishore k]

Hi Alan,

thank you for the your idea, i have tried the pivot option earlier. But i have problem with pivot data, cause if i have huge number of transaction in year close, my data will get mess up if i formulate in Pivot condition.. is there any formula you can help me with pls..

 

[alansidman]

No further ideas without seeing your data. Suggest you upload a representative sample of your data to a third party site, ie. Dropbox.com, Box.net, etc.