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
Solved! Go to Solution.
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |