Can we insert column based on the header name?

Help Studio
1

Hi all,
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.

2

@Bonus
for this we would suggest following flow:

  • retrieve the index/position for the Country column
  • incorporate the result from above within the column addition