Attached is a method using the function CHOOSECOLS
I have:
converted your range A:G into a table object
Put the columns to choose in column J
Wrote a small formula in cell AD2
Attached is a method using the function CHOOSECOLS
I have:
converted your range A:G into a table object
Put the columns to choose in column J
Wrote a small formula in cell AD2