To insert column into excel, we can either use ‘insert/delete columns’, ‘insert columns’ or ‘add data column’. Is there a way to add column based on finding the header name? Example: if there’s a header that’s called “Country”, then add a column next to it.
for this we would suggest following flow:
- retrieve the index/position for the Country column
- incorporate the result from above within the column addition