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

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

Unfortunately cannot upload screenshot to comment

Replace Null and Deduplicate.yxmd