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

[nonono]

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

MAY Row Labels Count of QTY Tester Run Product Ideal UPH Total planned run time Ideal Tested die Actual tested die OEE % UnSchedule Down Schedule Down Ideal Time ODTS001 50 ODTS001 PGF,PJQ,PJR,PJV,PJZ,PKS 6429 #REF! #REF! 2189080 #REF! #REF! #REF! PGF 8 ODTS002 6429 #REF! #REF! 1937976 #REF! #REF! #REF! PJQ 22 ODTS003 6429 #REF! #REF! 196896 #REF! #REF! #REF! PJR 2 ODTS004 6429 #REF! #REF! 1796528 #REF! #REF! #REF! PJV 2 ODTS005 6429 #REF! #REF! 2569344 #REF! #REF! #REF! PJZ 4 ODTS006 6429 #REF! #REF! 2911184 #REF! #REF! #REF! PKS 12 STSEP005 6429 #REF! #REF! 2401004 #REF! #REF! #REF! STSEP009 6429 #REF! #REF! 2347556 #REF! #REF! #REF! ODTS002 53 STSEP010 6429 #REF! #REF! 2010326 #REF! #REF! #REF! PGF 3 AVERAGE #REF! 18359894 #REF! PJQ 6 AVERAGE #REF! PJR 3 PJV 4 PJZ 19 PKS 18 ODTS003 58 PJQ 34 PJZ 24 ODTS004 34 PGF 4 PJQ 20 PJV 2 PJZ 8 ODTS005 16 PJQ 6 PJR 6 PJZ 2 PKS 2 ODTS006 48 PGF 4 PJQ 4 PJR 2 PJU 2 PJV 19 PJZ 11 PKS 6 STSEP005 2 PGW 2 STSEP009 22 PGF 12 PGT 5 PGV 1 PGW 2 PKS 2 STSEP010 17 PGF 13 PGW 2 PJQ 1 PKS 1 Grand Total 300 <tbody> </tbody>

<tbody>
</tbody>

 

[sheetspread]

If your pivot table is in tabular view with repeating labels, you can try something like here:

https://www.mrexcel.com/forum/excel-questions/1063647-help-combining-values-excel.html

 

[nonono]

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...

{=TEXTJOIN(",",TRUE,IF($A$2:$A$11=$D1,$B$2:$B$11,""))}

=consolidatelist($A:$A,$R:$S,1,2)

hope someone can help me out

 

[nonono]

i manage to make the table into tabular and it works !!! thank you for your help