How to fill out a table with above result

[DanFromMontreal]

Dear community,

I'm importing data from a PDF file and the table in not completely filled out.... just like a pivot table.

In order to analyze the data, it has to be complete.

I can fill it out easily in Excel using the search empty cell and.... but this adds an extra step.... and not sure everyone knows how to do it.

How can I do it in PowerQuery while I'm transforming my data?

Any suggestion would be helpfull.

Imported data				Final Result
Column1	Column2	Column3	Results		Column1	Column2	Column3	Results
1aa	2aa	3aa	85		1aa	2aa	3aa	82
			75		1aa	2aa	3aa	84
			71		1aa	2aa	3aa	92
		3bb	72		1aa	2aa	3bb	77
	2bb	3cc	82		1aa	2bb	3cc	100
			85		1aa	2bb	3cc	74
		3dd	80		1aa	2bb	3dd	90
			70		1aa	2bb	3dd	99
1bb	2cc	3ee	76		1bb	2cc	3ee	87
			86		1bb	2cc	3ee	78
			83		1bb	2cc	3ee	94
	2dd	3ff	98		1bb	2dd	3ff	90
			99		1bb	2dd	3ff	75
			89		1bb	2dd	3ff	76
			81		1bb	2dd	3ff	80
			88		1bb	2dd	3ff	90

[jgeddes · Accepted solution]

You can use the Table.FillDown() function to replace null values with the value above. 

Table.FillDown - Microsoft Learn