How do I fill horizontally (across columns but within the same row)? I need the solution to be generic. So setting the values to a hard coded string is not sufficient.

[Trifacta_Alumni]

Just wanted to update the thread with something else I have learned:

You can specify a range of columns in a field as follows: colname1~colname2

This accomplishes the same thing as switching to column view, clicking a column, and then clicking Invert Selection.

[446193eada4dc478fb22]

Thanks Nathanael, that's an easier solution. Kind regards,