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
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
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>
Last edited: