Forum Discussion
Transform table (fill in when missing the first two characters)
Hi, In case there are six spaces in the beginning of my column in PowerQuery, I would like to fill them up with the same six characters as in the row above. Below is an example: What woul...
Hi Anonymous
- Highlight the Column
- In the Ribbion Add Column > Custom Column and add this
if Text.Contains([Column1] , "-") then Text.BeforeDelimiter([Column1], " -") else null- Then Highlight the new Column and go to Transform in the ribbion
- Click on Fill and choose down. This will fill the values below
- Add another custom column and add this
if Text.Contains([Column1] , "-") then [Column1] else [Custom] & " - " & [Column1]Hope this helps
Joe
If you found my answer helpful and it solved your issue, please accept as solution
