Linked pivot table report to extract from large dataset

Hi All,

I have a massive dataset where I loose data in the original file due to exceeding excel row limit.

I've linked it to another workbook through a pivot table report.

I would like to extract the relevant data that contains a specific code identifier (crude example at bottom)

I can filter for the code identifier when that variable is in the "rows" area of the pivot table fields and I see how many there are (85) when that filtered variable is placed in the "count" field.

Ultimately, I would like to see the entire row that code identifier is associated with from the original dataset in this new workbook (the full row for all 85), extracted through the pivot table (or another approach if it exists). How would I go about getting the rest of the data associated with the code identifier?

A B
1 Code rest of data
2 123 xyz <<<<<<<<<<How to get this entire row

nvm...double click the count value auto created new sheet with all data

Hi

load the data into PowerQuery, then filter the values to your needs and load into a table in Excel or into a pivot

if you have an example of the data you load, would be easier to show the solution