In the query editor, there is a way to "Fill Down" or "Fill Up" in a column. It would be useful to have a way to Fill-Right or Fill-Left across a row.
Agree. Would like this a fill right or left. My purpose is to prepare the data for an unpivot. Sometimes a column name is intended to span multiple columns but shown as blank for visual/reporting purposes. If I can FILL RIGHT then those spaces will be properly filled with data for the unpivot to work correctly. Am I making sense? Alternately there could be a bit more intelligence in the unpivot to cover these situations.
