This is an Early Access Feature - you need to enable it first
When matching imported data to transaction properties, there's an option to enable a Formula that will transform the value from the CSV cell.
The relevant variables and functions are:
value
- cell's value
index
- current row index
col(columnName[, index])
- reads value from another column (and possibly another row)