Hi,
I have data on seven worksheets, examples below:
[TABLE="width: 299"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2, align: left"]Worksheet 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Mike[/TD]
[TD="align: center"]2345[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Michael[/TD]
[TD="align: center"]5678[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Nancy[/TD]
[TD="align: center"]4567[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Alpha[/TD]
[TD="align: center"]6789[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Bravo[/TD]
[TD="align: center"]7890[/TD]
[TD="align: center"]9000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2, align: left"]Worksheet 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]5190[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Graham[/TD]
[TD="align: center"]2530[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mark[/TD]
[TD="align: center"]5165[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Sara[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]David[/TD]
[TD="align: center"]8565[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 299"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2, align: left"]
Desired result[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]5190[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Sara[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mike[/TD]
[TD="align: center"]2345[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Michael[/TD]
[TD="align: center"]5678[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Nancy[/TD]
[TD="align: center"]4567[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Alpha[/TD]
[TD="align: center"]6789[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Bravo[/TD]
[TD="align: center"]7890[/TD]
[TD="align: center"]9000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Graham[/TD]
[TD="align: center"]2530[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mark[/TD]
[TD="align: center"]5165[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]David[/TD]
[TD="align: center"]8565[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
</tbody>[/TABLE]
Please help and oblige.
Regards,
SIFS
I have data on seven worksheets, examples below:
[TABLE="width: 299"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2, align: left"]Worksheet 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Mike[/TD]
[TD="align: center"]2345[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Michael[/TD]
[TD="align: center"]5678[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Nancy[/TD]
[TD="align: center"]4567[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Alpha[/TD]
[TD="align: center"]6789[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Bravo[/TD]
[TD="align: center"]7890[/TD]
[TD="align: center"]9000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2, align: left"]Worksheet 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]5190[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Graham[/TD]
[TD="align: center"]2530[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mark[/TD]
[TD="align: center"]5165[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Sara[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]David[/TD]
[TD="align: center"]8565[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 299"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2, align: left"]
Desired result[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Name[/TD]
[TD="align: center"]Contact number[/TD]
[TD="align: left"]Quantity[/TD]
[TD="align: left"]Company[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD="align: center"]5190[/TD]
[TD="align: center"]10000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Sara[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mike[/TD]
[TD="align: center"]2345[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Michael[/TD]
[TD="align: center"]5678[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Nancy[/TD]
[TD="align: center"]4567[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Alpha[/TD]
[TD="align: center"]6789[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Bravo[/TD]
[TD="align: center"]7890[/TD]
[TD="align: center"]9000[/TD]
[TD="align: left"]Amazon[/TD]
[/TR]
[TR]
[TD="align: left"]Graham[/TD]
[TD="align: center"]2530[/TD]
[TD="align: center"]5000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]Mark[/TD]
[TD="align: center"]5165[/TD]
[TD="align: center"]3000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
[TR]
[TD="align: left"]David[/TD]
[TD="align: center"]8565[/TD]
[TD="align: center"]8000[/TD]
[TD="align: left"]Facebook[/TD]
[/TR]
</tbody>[/TABLE]
Please help and oblige.
Regards,
SIFS