We have 4,800 rows of data in our excel spreadsheet and there is one column that needs to have the data separated in to 4 different columns. It is too random to create rules that automate the process, but "Fixed Width" text to column techniques could be used to separate the first two columns. An example cell we need to split is as follow:
Signs & Symbols - line artA New Guinea [login to view URL] Wallaby belongs to the Kangaroo family of [login to view URL] Guinea is part of the Malay Archipelago off the North coast of [login to view URL], marsupial, AustraliaSE
In this example, the new cells would contain the information like this:
Signs & Symbols line art A New Guinea wallaby. The Wallaby belongs to the Kangaroo family of [login to view URL] Guinea is part of the Malay Archipelago off the North coast of Australia. animal, marsupial, AustraliaSE
The first two are categories, then the title, then the description, then the keywords.
Please only bid on this if you have a small team who can start today as we need it asap.
I will complete on average 400 to 500 rows per day. Quality work provided. I have extensive Excel experience, this project will be done before the deadline and will be done right. You can also be assured that I will not scam you on the time, what time you get billed for will be the actual time that I work.