clean up data configuration on .csv file
- Status: Closed
- Prize: $20
- Entries Received: 16
- Winner: divibj
Contest Brief
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.
.csv attached
The first entry with the data fixed will be awarded immediately
Recommended Skills
Employer Feedback
“Awesome, intelligent freelancer!”
revamp365, United States.
Top entries from this contest
-
blui88 India
-
CarolinaCardoza Venezuela
-
languagedr Bangladesh
-
bktk Pakistan
-
ripasahasl India
-
testotorko Bulgaria
-
mdsajjad876 Bangladesh
-
mariaamjad85 Pakistan
-
mariaamjad85 Pakistan
-
mariaamjad85 Pakistan
-
mariaamjad85 Pakistan
-
bktk Pakistan
-
bktk Pakistan
-
Humayun491 Pakistan
-
bktk Pakistan
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!