Hi,
I have data on seven worksheets, examples below:
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
I need to consolidate this data in a way that same name and mobile number come together. For example, in below consolidated sheet, Sara has same contact number like Richard so Sara is reported with Richard and Richard's both entries are coming together.
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Please help and oblige.
Regards,
SIFS
I have data on seven worksheets, examples below:
Worksheet 1 | |||
Name | Contact number | Quantity | Company |
Richard | 1234 | 10000 | Amazon |
Mike | 2345 | 5000 | Amazon |
Michael | 5678 | 3000 | Amazon |
Nancy | 4567 | 5000 | Amazon |
Alpha | 6789 | 8000 | Amazon |
Bravo | 7890 | 9000 | Amazon |
Worksheet 2 | |||
Name | Contact number | Quantity | Company |
Richard | 5190 | 10000 | |
Graham | 2530 | 5000 | |
Mark | 5165 | 3000 | |
Sara | 1234 | 5000 | |
David | 8565 | 8000 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
I need to consolidate this data in a way that same name and mobile number come together. For example, in below consolidated sheet, Sara has same contact number like Richard so Sara is reported with Richard and Richard's both entries are coming together.
Desired result | |||
Name | Contact number | Quantity | Company |
Richard | 1234 | 10000 | Amazon |
Richard | 5190 | 10000 | |
Sara | 1234 | 5000 | |
Mike | 2345 | 5000 | Amazon |
Michael | 5678 | 3000 | Amazon |
Nancy | 4567 | 5000 | Amazon |
Alpha | 6789 | 8000 | Amazon |
Bravo | 7890 | 9000 | Amazon |
Graham | 2530 | 5000 | |
Mark | 5165 | 3000 | |
David | 8565 | 8000 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Please help and oblige.
Regards,
SIFS