Move 1 row up

[adiwsusanto]

So... My Source data is skewed up resulting to data in Column1 to be on a different Row. In Excel, I can easily Edit JUST this column to move up & problem solved. In PowerBI Edit Query, I have been banging myself and can't solved it. Any suggestions welcome.

Column1	Column2	Column3	Column4
	9	$$$	MMM
$$$
	9	$$$	MMM
$$$

[TomMartens · Accepted solution]

Hey,

in the Query Editor

• mark Column1
• from the context menu choose Fill -> up
• mark Colum2
• from the filter menu in column heacher chooe Remove empty

Hopefully this is what you are looking for

Regards

Tom 

[adiwsusanto]

I was thinking along those lines but Fill up doesn't work on my dataset, The Blank looks blank but Fillup doesn't fill it up.

[adiwsusanto]

OK. I change the datatype of Column1 and fill up now works. Thanks

[TomMartens]

Glad, you found your solution