Excel

[GSankar2312]

Hi Guys,

I have two distinct data sheet one is pending to supply and second pending to prepare I need to pivot or create a table with a filter tabs as customer #, Contract #, Sales person, and Family Description. 

Table should contain Item, Description and Qty Pending to supply and Qty Pending to prepare in one sheet.

please advise with the correspondence. 

thank you. 

[#2]

Hi @GSankar2312 

Please find attached is the file, combine the sheets in the master data with Power Query & turn your data into pivot table.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer.