Extract values from a column

THANK YOU SO MUCH QUANG! IT WORKS PERFECTLY 100%!

Last query. How do I extract the information under Nominal, Upper, and Lower columns, which belong to M.I TPG and PG types, to rows 111, 112, and 113 respectively, under the section Measuring Instrument Used?

Subsequently, whenever there are new entries with either PG or TPG type, the Nominal, Upper, and Lower info, which belong to the new entries, will be extracted and pasted beside its respectively M.I type.

I have attached my workbook and filled up the cells in yellow for your ease of convenience.

Jude