Repeat the nth value of the the given column for every row in a column.
field (required) Column to pick from.
n (required) Offset from top of column. Must be an integer greater than 0. The integer must also be constant (i.e. don't pass in columns with multiple distinct values).
- If Quarter has”Q1″,”Q2″,”Q3″and”Q4″, the result would be”Q2″,”Q2″,”Q2″and”Q2″.