Get data from PIVOT column

AlexBN

New member
Joined
Jan 26, 2021
Messages
11
Reaction score
0
Points
0
Excel Version(s)
365
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.
 
This is impossible to do without a sample workbook - please attach one.
 
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.
 

Attachments

  • Elite 01-25.xlsx
    160.2 KB · Views: 5
Last edited:
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).
 

Attachments

  • ExcelGuru11020 Elite 01-25.xlsx
    160.6 KB · Views: 12
Thank you, p45cal. That's it. Best regards.
 
Last edited:
Back
Top