Keeping Appended Data In Sync After Data Connection Refresh

[schnide]

I have a table with two columns in Excel:

	A	B
1	United Kingdom	London
2	United States of America	Washington DC
3	France	Paris
4	Spain	Madrid
5	Japan	Tokyo

<tbody>
</tbody>

Column A is populated by an external data connection from a CSV file. Column B is data that I then manually append with metadata, directly in Excel.

This is all fine until additional data is added to the CSV file. When I refresh the data in Excel, it pushes down column A only and so column B becomes out of sync:

	A	B
1	United Kingdom	London
2	United States of America	Washington DC
3	Italy	Paris
4	France	Madrid
5	Spain	Tokyo
6	Japan

<tbody>
</tbody>

..and of course the metadata is wrong.

Can anyone suggest a way to setup the sheet so that column B will dynamically push down when new rows are added, like so?

	A	B
1	United Kingdom	London
2	United States of America	Washington DC
3	Italy
4	France	Paris
5	Spain	Madrid
6	Japan	Tokyo

<tbody>
</tbody>

..so that I can continue to add the metadata and keep it synced up? My guess is that there probably isn't a way since Excel wouldn't know how to handle a row being removed if an entry present in the CSV file was no longer there on a subsequent refresh.

However, all thoughts welcome (and appreciated as always)!

 

[schnide]

*bump!*

 

[schnide]

Final bump, I guess.. six pages back already after the first one!