Extracting selected data from PivotTable and placing it into the table?

nonono

Board Regular
Joined
Jul 25, 2018
Messages
59
Sorry for disturbing you guys, but I could use some help with extracting some data from the pivot table and placing it into the table
As you can see there is a pivot table on the right. There will be only 2 types of tester but it is dynamic range as I do not know which tester will be use every month

Those 2 are will start with STSEP* & ODTS*.
The run product will be dynamic as well..

How do I do for all the run product in column B4:B11 like B3 because I done that manually by typing it in....
Hope someone can help me out with that
D0ekIu4.png
MAYRow LabelsCount of QTY
TesterRun ProductIdeal UPHTotal planned run timeIdeal Tested dieActual tested dieOEE %UnSchedule DownSchedule DownIdeal TimeODTS00150
ODTS001PGF,PJQ,PJR,PJV,PJZ,PKS6429#REF!#REF!2189080#REF!#REF!#REF!PGF8
ODTS0026429#REF!#REF!1937976#REF!#REF!#REF!PJQ22
ODTS0036429#REF!#REF!196896#REF!#REF!#REF!PJR2
ODTS0046429#REF!#REF!1796528#REF!#REF!#REF!PJV2
ODTS0056429#REF!#REF!2569344#REF!#REF!#REF!PJZ4
ODTS0066429#REF!#REF!2911184#REF!#REF!#REF!PKS12
STSEP0056429#REF!#REF!2401004#REF!#REF!#REF!
STSEP0096429#REF!#REF!2347556#REF!#REF!#REF!ODTS00253
STSEP0106429#REF!#REF!2010326#REF!#REF!#REF!PGF3
AVERAGE#REF!18359894#REF!PJQ6
AVERAGE#REF!PJR3
PJV4
PJZ19
PKS18
ODTS00358
PJQ34
PJZ24
ODTS00434
PGF4
PJQ20
PJV2
PJZ8
ODTS00516
PJQ6
PJR6
PJZ2
PKS2
ODTS00648
PGF4
PJQ4
PJR2
PJU2
PJV19
PJZ11
PKS6
STSEP0052
PGW2
STSEP00922
PGF12
PGT5
PGV1
PGW2
PKS2
STSEP01017
PGF13
PGW2
PJQ1
PKS1
Grand Total300

<tbody>
</tbody>

<tbody>
</tbody>
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

nonono

Board Regular
Joined
Jul 25, 2018
Messages
59
my pivot table might looks like a tabular view but the it isnt with repeating labels like the url you posted ...

However I tried to test out the formula provided.... and it still doesnt work for me...
Code:
{=TEXTJOIN(",",TRUE,IF($A$2:$A$11=$D1,$B$2:$B$11,""))}
Code:
=consolidatelist($A:$A,$R:$S,1,2)

hope someone can help me out :(
 

nonono

Board Regular
Joined
Jul 25, 2018
Messages
59
i manage to make the table into tabular and it works !!! thank you for your help
 

Forum statistics

Threads
1,136,340
Messages
5,675,202
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top