I have a table with two columns in Excel:
<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:
<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?
<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)!
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)!
Last edited: