How to fill out a table with above result

Question

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.&nbsp;Imported data&nbsp;&nbsp;&nbsp;Final Result&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column1Column2Column3Results&nbsp;Column1Column2Column3Results1aa2aa3aa85&nbsp;1aa2aa3aa82&nbsp;&nbsp;&nbsp;75&nbsp;1aa2aa3aa84&nbsp;&nbsp;&nbsp;71&nbsp;1aa2aa3aa92&nbsp;&nbsp;3bb72&nbsp;1aa2aa3bb77&nbsp;2bb3cc82&nbsp;1aa2bb3cc100&nbsp;&nbsp;&nbsp;85&nbsp;1aa2bb3cc74&nbsp;&nbsp;3dd80&nbsp;1aa2bb3dd90&nbsp;&nbsp;&nbsp;70&nbsp;1aa2bb3dd991bb2cc3ee76&nbsp;1bb2cc3ee87&nbsp;&nbsp;&nbsp;86&nbsp;1bb2cc3ee78&nbsp;&nbsp;&nbsp;83&nbsp;1bb2cc3ee94&nbsp;2dd3ff98&nbsp;1bb2dd3ff90&nbsp;&nbsp;&nbsp;99&nbsp;1bb2dd3ff75&nbsp;&nbsp;&nbsp;89&nbsp;1bb2dd3ff76&nbsp;&nbsp;&nbsp;81&nbsp;1bb2dd3ff80&nbsp;&nbsp;&nbsp;88&nbsp;1bb2dd3ff90

jgeddes · Accepted Answer

You can use the Table.FillDown() function to replace null values with the value above.&nbsp;
Table.FillDown - Microsoft Learn&nbsp;

Forum Discussion

How to fill out a table with above result

1 Reply

Related content

Table Pivot, result explanation

Rank Issue - Table vs Filter Results

Combining three CONCATENATEX Measures with results from two Tables

Getting results from two tables

Filter table using another table result

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