Mar 30 2020 10:39 PM
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.
Mar 31 2020 05:07 AM - edited Mar 31 2020 05:08 AM
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.