How to Fill up or down base on ID column in Power Query?

[TungNguyen_19]

Dear everyone,

I have this table after Pivot 

ID	LOLO	BARGE	TRUCKING
AMFU301452	null	33	null
AMFU301452	8	null	null
BMOU303113	14	null	null
BMOU303113	null	66	null
BMOU303113	null	null	138

How to Fill up or Fill down base on ID column in Power Query? The result will be like this:

ID	LOLO	BARGE	TRUCKING
AMFU301452	8	33	null
AMFU301452	8	33	null
BMOU303113	14	66	138
BMOU303113	14	66	138
BMOU303113	14	66	138

In power query we only have option Fill down or Fill up only so I think this must be customized by M Language. Can anyone help me, many thanks to you guys ❤️ 

[spinfuzer · Accepted solution]

Group By ID and then Operation All Rows.

Change the each _ part of the formula to

each Table.FillDown(Table.FillUp(_,Table.ColumnNames(_)),Table.ColumnNames(_))