How do I add rows on top of table basis a reference text?

[kaushik_birmiwal]

I have excel files where table start row is inconsistent. I would like to add rows on top of the table so that all files can be made consistent in terms of the format. Two examples of tables are as follows:

Table 1:

INSTID	UKPRN	Region of institution	Name	SLC/LEAs/ SAAS/DEL(NI)
0047	10000291	EAST	Anglia Ruskin University	40747
0108	10007759	WMID	Aston University	25388
0048	10000571	SWES	Bath Spa University	24083
0109	10007850	SWES	The University of Bath	31616

Table 2: 

INSTID	UKPRN	Region of institution	Name	SLC/LEAs/ SAAS/DEL (NI)
0026	10007152	EAST	University of Bedfordshire	46258
0127	10007760	LOND	Birkbeck College(#4)	3347
0052	10007140	WMID	Birmingham City University	43389
0110	10006840	WMID	The University of Birmingham	65945

Basically, I need the workflow to find reference of "INSTID" and accordingly add number of rows above the table so that the count of rows on above the row containing "INSTID" is 10. 

How would I go about adding these rows?  Thank you very much! 

[MichalM]

@kaushik_birmiwal 

Wouldn't removing the empty rows be easier? If that's the case, using a simple Filter is going to do the trick

[afv2688 · Accepted solution]

Hello @kaushik_birmiwal ,

Is this what you are looking for?

Cheers

[kaushik_birmiwal]

Hi @afv2688 ,

The solution works perfectly well for me.

Thanks again!!

Regards,

Kaushik

[kaushik_birmiwal]

@MichalM 

Removing blank rows will not serve the purpose in this case as i need to Build a Concatenate formula for all Rows above "INSTID" across all columns. The Information in columns is quite vital in this case.

Thanks for your reply.