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.
6 Comments
- any solution/ideas on this ?
- Still need this!
- Would really be nice to have this feature built in. A workaround where you transpose the table might assist but a built in Fill Right /Fill Left will really be a gem
- 'To fill blanks with values from another field, try this: = Table.ReplaceValue(#"Last Step",null,each [Field with Values],Replacer.ReplaceValue,{"Field to Fill 1", "Field to Fill 2", "Field to Fill 3"})
- 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.
- Status added:Needs Votes
