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

[TABLE="width: 300"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]41001[/TD]
[TD]MAY-19[/TD]
[TD]350[/TD]
[/TR]
[TR]
[TD]41001[/TD]
[TD]MAY-19[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]51000[/TD]
[TD]JUN-19[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]51000[/TD]
[TD]JUN-19[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]41011[/TD]
[TD]APR-19[/TD]
[TD]700[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2
[TABLE="width: 300"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]41001[/TD]
[TD]550[/TD]
[TD]MAY-19[/TD]
[/TR]
[TR]
[TD]51000[/TD]
[TD]1100[/TD]
[TD]JUN-19[/TD]
[/TR]
[TR]
[TD]41011[/TD]
[TD]700[/TD]
[TD]APR-19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.