Results 1 to 5 of 5

Thread: Get data from PIVOT column

  1. #1
    Seeker AlexBN's Avatar
    Join Date
    Jan 2021
    Posts
    11
    Articles
    0
    Excel Version
    365

    Get data from PIVOT column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all,
    I have two sheets in same workbook. There is PIVOT table in first and ordinary table in second. In both tables are some players with some data. Players in ordinary table are Subset of PIVOT table. It means that all players which are in Ordinary table are also in PIVOT but all players from PIVOT are not in ordinary.
    Now, I need to add column in ordinary table with associated data from PIVOT. Excel must go in each row (each player) in ordinary table, then found associated data for that player in PIVOT.
    Thank you in advance.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,886
    Articles
    0
    Excel Version
    365
    This is impossible to do without a sample workbook - please attach one.

  3. #3
    Seeker AlexBN's Avatar
    Join Date
    Jan 2021
    Posts
    11
    Articles
    0
    Excel Version
    365
    There is sample. In Sheet 'Pokret' in column C, I need to get data from Pivot table which is in Sheet 'PivotPart'.
    Also, if it is too complicated, I can copy data from Pivot as Values and put it in new Sheet and collect data from there.
    Attached Files Attached Files
    Last edited by AlexBN; 2021-01-26 at 02:53 PM. Reason: Add attachment

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,886
    Articles
    0
    Excel Version
    365
    In sheet Pokret, column C some GETPIVOTDATA formulae.
    In column D of the same sheet is another, more direct, way of getting the data directly from Partije sheet which you might like to consider.
    You could very probably also use Power Query (if your version Excel is Excel 2016 or later).
    Attached Files Attached Files

  5. #5
    Seeker AlexBN's Avatar
    Join Date
    Jan 2021
    Posts
    11
    Articles
    0
    Excel Version
    365
    Thank you, p45cal. That's it. Best regards.
    Last edited by AlexBN; 2021-01-27 at 08:12 AM.

Posting Permissions

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