clean up data configuration on .csv file

Stav: Closed
Odměna: $20
Přijatých návrhů: 16
Vítěz: divibj

Winner

Instrukce k soutěži

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

Doporučené dovednosti

Winner

Zadejte podobnou soutěž

Zpětná vazba od zaměstnavatele

“Awesome, intelligent freelancer!”

revamp365, United States.

Nejlepší návrhy této soutěže

blui88 India

0
CarolinaCardoza Venezuela

0
languagedr Bangladesh

0
bktk Pakistan

0
ripasahasl India

0
testotorko Bulgaria

0
mdsajjad876 Bangladesh

0
mariaamjad85 Pakistan

0
mariaamjad85 Pakistan

0
mariaamjad85 Pakistan

0
mariaamjad85 Pakistan

0
bktk Pakistan

0
bktk Pakistan

0
Humayun491 Pakistan

0
bktk Pakistan

0

Zobrazit více příspěvků

Veřejná nástěnka k vyjasnění projektu

languagedr
- Před 4 let
Please check my entry #15
- Před 4 let
divibj
- Před 4 let
Completed. please check #13
- Před 4 let
Pořadatel soutěže
- Před 4 let
https://youtu.be/dnPRaCp-UUk
- Před 4 let
vw7184529vw
- Před 4 let
I am working on this Project. I have finished halfway. I will be updating the final file soon.

Thank you for your patience
- Před 4 let
bktk
- Před 4 let
sir can you elaborate according to your requirement i am ready to start work on contest
- Před 4 let