Kris on 24 Feb 2018 01:39:58
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.
- Comments (5)
RE: Fill Right or Fill Left
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.
RE: Fill Right or Fill Left
'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"})
RE: Fill Right or Fill Left
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
RE: Fill Right or Fill Left
Still need this!
RE: Fill Right or Fill Left
any solution/ideas on this ?