Question: How to fill in the rest of the column per each deal

[Pw123]

I think this might be a multi-row formula, but I can't quite figure out how to fill out the rest of the column PER each deal (rather than the entire column).

I went from the dataset under "BEFORE" to the dataset under "CURRENT". I'm trying to fill out each of the "<Region> Rep" columns with a static value for each deal, so that it looks like the dataset under "AFTER". I'm okay to re-do the process starting from "BEFORE", but just sharing where I'm currently at as well.

Thanks in advance!

[gawa · Accepted solution]

@Pw123  If I got it correctly, you'd like to operate Multi-row formula & Multi-field formula simultaneously. The combo of Transpose and Cross-tab will help you create the dynamic workflow. Be sure to properly set the option "Dynamic or Unknow Columns" to cater for dynamic input(unknown schema).

[Pw123]

Thank you so much, this is exactly what I needed!