+ Reply to Thread
Results 1 to 2 of 2

New to Excel !! Need help on building a simple Pivot table

  1. #1
    Registered User
    Join Date
    06-09-2021
    Location
    Hyderabad, India
    MS-Off Ver
    2007
    Posts
    1

    New to Excel !! Need help on building a simple Pivot table

    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.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: New to Excel !! Need help on building a simple Pivot table

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Building simple pivot table
    By jaryszek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-05-2019, 08:18 AM
  2. Need help building out a pivot table for the attached data
    By AhMelody in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2016, 04:07 PM
  3. building a stats. from pivot table
    By ciapul12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-10-2014, 08:11 AM
  4. Help with building a pivot table
    By AllanNWSPP in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-15-2013, 02:29 PM
  5. building a pivot table to see total cost
    By sjhill60 in forum Excel General
    Replies: 1
    Last Post: 10-20-2011, 01:46 AM
  6. Building Pivot table from Access data
    By Newbie in forum Excel General
    Replies: 1
    Last Post: 07-31-2006, 07:28 AM
  7. [SOLVED] Pivot Table Grouping (Excel 2000)- This has to be simple
    By uncoolfester in forum Excel General
    Replies: 5
    Last Post: 10-21-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1