replace the null value and remove dupe

[k3pineapple]

Hi

Im stuck on this

Seeking your help to clean the data format

Input

Code	Type1	Type2	Platform1-1	Platform1-2	Platform2	Platform3-1	Platform3-2
aaaaaaa	Fruit	Fruit	4335	kyc
aaaaaaa	Fruit	Fruit				Company1	abc
aaaaaaa	Fruit	Fruit	4335	kyc
aaaaaaa	Fruit	Fruit				Company1	abc
bbbbbbb	Fruit	Fruit
ccccccc	Vegi	Vegi			k3b2

Output

Code	Type1	Type2	Platform1-1	Platform1-2	Platform2	Platform3-1	Platform3-2
aaaaaaa	Fruit	Fruit	4335	kyc		Company1	abc
bbbbbbb	Fruit	Fruit
ccccccc	Vegi	Vegi			k3b2

Thank you very much

[ed_hayter · Accepted solution]

Attached workflow to deduplicate and remove nulls in two different ways.

Unfortunately cannot upload screenshot to comment