Assigning column values to a heading

[Cranners]

Hi,
Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me
For context, I have data in a primary table structured like below:

Name	City	Level
Jeff	Perth	5
Mark	London	2
Phil	New York	4

<tbody>
</tbody>

The names in which, are being input into another sheet using a vlookup, as below:

	Jeff	Mark	Phil
Height	194	175	166
Weight	81	76	60

<tbody>
</tbody>

With the following formula: =IFERROR(VLOOKUP(COLUMN()-2,'Sheet1'!$C$5:$F$50,ROW(),0), "")
dragged across, accounting for small formatting deviations.

What I'm trying to achieve, is if I add a row to my first table, as below:

Name	City	Level
Jeff	Perth	5
Jim
Mark	London	2
Phil	New York	4

<tbody>
</tbody>

The second table, will react like below:

	Jeff	Jim	Mark	Phil
Height	194		175	166
Weight	81		76	60

<tbody>
</tbody>

Instead of what I'm currently getting below:

	Jeff	Jim	Mark	Phil
Height	194	175	166
Weight	81	76	60

<tbody>
</tbody>

So, essentially, I want the data below the heading in the second sheet, to move along with the heading if a new Name is added on the first sheet.

Sorry if this is a little confusing to follow

Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ng-cell-movement-post5295743.html#post5295743

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).