Create filename based on two columns data

Hi,

I’m looking for a solution to create Excel files with two columns of data inside a loop. I can create files with one column, but I’m struggling with two or more.

should look like -

  1. field location → ABC, DEF

  2. field country → USA, FRA

Output during the loop should be Excel files like this

ABC_USA.xlsx

DEF_FRA.xlsx