Look result that will add rows

[papilo]

Dear Gurus in the house I need urgent help.
I have a dataset of over 100,000 rows containing names of agents and the documents they provided.
out this this list, I have selected just about 5000 on a separate workbook.
I want a formula that will look up each name on my new workbook and pick the agent from the master list then, list the agent name on rows according to the the number of documents provided on the master list.
It means that on my list, I have one row for each agent but, want the result to push down the agent below, insert rows that equals the number of documents listed on master list.

Master list
Agents	Documents provided
Ventures Limited	Ventures Chart.ppt
Ventures Limited	work evidence.jpg
Ventures Limited	Bank Reference.jpg
Ventures Limited	Tax.jpg
Ventures Limited	Ventures Amanayanbo.jpg
Ventures Limited	Venture Form 7.zip
Ventures Limited	vat.jpg
Ventures Limited	Venture Article.zip
Ventures Limited	Certificate of Registration.jpg
Ventures Limited	List of Equipment.jpg
Ventures Limited	Venture Form 2.zip
Ventures Limited	Venture HSE.zip
Ventures Limited	Venture covering letter.doc
Ventures Limited	Venture QAQC.zip
RESOURCES LIMITED	ORGANOGRAM.pdf
RESOURCES LIMITED	Director Signature Specimen.JPG
RESOURCES LIMITED	Eroton PO.pdf
RESOURCES LIMITED	HES MANUAL.pdf
RESOURCES LIMITED	QUALITY MANAGEMENT SYSTEM MANUAL.pdf
RESOURCES LIMITED	DPR PERMIT.pdf
RESOURCES LIMITED	OSM Offshore AS_20190607_071617.pdf
RESOURCES LIMITED	Tax Clearance Certificate.pdf
RESOURCES LIMITED	VAT REGISTRATION.pdf
RESOURCES LIMITED	CAC 7A.pdf
RESOURCES LIMITED	MEMORANDUM AND ARTICLES OF ASSOCIATION.pdf
RESOURCES LIMITED	CAC 2A.pdf
RESOURCES LIMITED	CAC CERTIFICATE.pdf
RESOURCES LIMITED	OEM Representation Letters.pdf
INTELL SOLUTIONS LIMITED	Health Safety Policy (3).pdf
INTELL SOLUTIONS LIMITED	C02-1 001.jpg
INTELL SOLUTIONS LIMITED	C07-1 001.jpg
INTELL SOLUTIONS LIMITED	file_extract_1.csv
INTELL SOLUTIONS LIMITED	Organisational Chart.pdf

Look up (to replicate as master above)
Agents	Documents provided
Ventures Limited
RESOURCES LIMITED
INTELL SOLUTIONS LIMITED

 

[hagia_sofia]

If I understand it correctly something like this?

=DROP(REDUCE("",A2:A4,LAMBDA(a,b,VSTACK(a,FILTER('[Master List.xlsx]Master List'!$A$2:$B$34,'[Master List.xlsx]Master List'!$A$2:$A$34=b)))),1)

 

[papilo]

If I understand it correctly something like this?

=DROP(REDUCE("",A2:A4,LAMBDA(a,b,VSTACK(a,FILTER('[Master List.xlsx]Master List'!$A$2:$B$34,'[Master List.xlsx]Master List'!$A$2:$A$34=b)))),1)

Hi Hagia_Sofia,
Thank you for your response. I am not at this level of Excel. If you could explain it will help me much.
Again, thank you.

 

[hagia_sofia]

Hello,

what the formula does is to stack upon each other the relevant part of columns "Agents" and "Documents provided" (as on the master list) for every "Agent" on the list.