Forum Discussion
how to repeat column value in PowerQuery
Ah, sorry, I didn't look carefully enough at your image, got too excited about fill down! lol
This function only works on 'null' values, so you'll need to select the column, click 'Replace Values'
Then use fill down.
amalrio This is one of my favourite Power Query functions.
UPDATE: I forgot to mention that it only works on null values, then picks up next non null value, so first you must:
Select the column,
Click Transform tab,
click 'Replace Values'
Replace 'Test' with 'null' (spelling must be exact match).
Then click Fill > Down.
Hi AllisonKennedy ,
thanks for the reply, but it did do anythin to to get me the expected table as in the image.
amalrio ,
There can be few ways.One can be.
Make all Test as null . In power Query -> Right click on Column and Replace "Test" with: null
Then use Fill Down - > https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
Replace remaining null with Test
Ah, sorry, I didn't look carefully enough at your image, got too excited about fill down! lol
This function only works on 'null' values, so you'll need to select the column, click 'Replace Values'
Then use fill down.
