Hello Everybody,
Iam new to excel and I need a small help from you guys. I've been asked to work on a pivot table which I never did before.
I was provided the sample table with below columns:
Date Carrier Fulfillment Centre Package Status
And I want to know which carriers are reporting late week wise ( eg: Week 1, Week 2). Carriers are Bluedart,Gati, Fedex etc. Fulfillment centre ( FC) are basically abbreviation nodes like QNAB, QNAI ( Any sample node name can be used).
The final data as per Pivot table should look like this:
Week 1 Week 2......
Bluedart
Gati
Fedex
Week 1 Week2 ....
QNAB
QNAI
I hope you got a gist of what Iam looking for. It would be great if you can help me out on this with any sample data. Thanks for your time.
Bookmarks