clean up data configuration on .csv file
- Durum: Closed
- Ödül: $20
- Alınan Girdiler: 17
- Kazanan: divibj
I have a .csv that has data configured in a bad way.
Most of the data will be easily copy and pasted, but specifically everything in the "Additional Info" row in the .csv is all appended and not formatted the same. We need to create a heading for each of the "fields" listed in within "additional info" and have the data placed properly within them rows.
If you use the "text to columns" function you will see that some of the rows have a different order or items. That is the issue. I need the data cleaned up. I don't know if this has to be done manually or can be done with a formula, but I need all the data separated from "more info" and organized as necessary
See screenshot below.
The first entry with the data fixed will be awarded immediately