Merge many columns according to two other columns ?

[Anonymous]

Hello everyone,

I'd need help to merge many columns according to two other columns.

On my table, I have this:

Num Transport	Traffic	Attribute 1	Attribute 2
123	Monday	Blue	null
123	Monday	null	Green
123	Tuesday	null	Yellow
123	Tuesday	Purple	null

And I'd like to have this:

Num Transport	Traffic	Attribute 1	Attribute 2
123	Monday	Blue	Green
123	Tuesday	Purple	Yellow

Could you help me please ? Thank you !

[Anonymous]

Thanks a lot it works!

[HotChilli · Accepted solution]

If it's always 2 columns to merge:

In Power Query, select the first 2 columns. Choose 'Group By' from the ribbon.

You need 2 aggregations (First one using MIN on attribute1, second one using MIN on attribute2)