Concluído

Format Excel/CSV file - 24 hour turn around

I have a CSV file which needs specific formatting:

Each row represents a product

1. In the _media_image column - image urls are given. If there is more than one url an extra row has been created (some products have around 3 images - creating 3 rows instead of one). I need the extra images for each product added into the one cell in the same row as the rest of the data. The images should be separated by a pipe character.

So rather than:

/o/l/[login to view URL]

/o/l/[login to view URL]

/o/l/[login to view URL]

The product row would have /o/l/[login to view URL]|/o/l/[login to view URL]|/o/l/[login to view URL] in the "_media_image" column.

2. Once item 1 is complete any rows which have ALL cells blank should be deleted.

The process above must be accurately performed without any mistakes. This would best be done with a formula etc rather than manually updating the file.

The file in question is attached.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Visual Basic, Captura de dados na web

Veja mais: start excel csv file, excel csv file format, read excel csv file plsql, convert time format from 12 hour to 24 hour in excel, convert standard time to military time in excel, excel 24 hour time formulas, excel convert 24 hour time to standard time, excel 12 hour time with am/pm, excel time format 12 hour, excel convert time to 24 hour format, convert csv to excel 2016, data entry, data processing, excel, excel csv file grapher, format descriptor csv file vba, create excel csv file web page, format addresses csv file outlook, excel csv file schema, macro export range data excel csv file

Acerca do Empregador:
( 1 comentário ) Cheltenham, Australia

ID do Projeto: #17901615

Concedido a:

HardWorker1989

Hi there. I can do the formatting as you have mentioned through formula :) Please send me the file and I will send the updated file within 6 hours from now :) Many thanks Saad.

$75 AUD em 1 dia
(101 Comentários)
7.0

13 freelancers estão ofertando em média $162 para esse trabalho

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mais

$200 AUD em 1 dia
(634 Comentários)
8.3
Webxpert4u

I am ready to create formula to automate this task. I can do it within 12 hours. I will make one row for each product if they have multiple images or single image and then will delete the blanks rows. Will put all Mais

$176 AUD in 0 dias
(295 Comentários)
7.8
Khurramz

Hi donut101! This can be done using formula. Please send me chat so that I can submit you a sample before you award project. Thanks

$50 AUD in 3 dias
(377 Comentários)
7.4
sergiuloghin

Hello! I can create a VBA script for you. That will do the trick. I can do it within 24 hours. You will not be dissapointed, I have a big 35% rehire rate. Thank you!

$141 AUD em 1 dia
(212 Comentários)
7.2
$88 AUD em 1 dia
(141 Comentários)
6.7
ianfosgate23

Hello there! I have come up with a formula/solution in mind for this one. I can have this one patched up and completed in an hr or so. Accurately and error-free. Feel free to send me a message. I look forward to workin Mais

$200 AUD in 0 dias
(145 Comentários)
6.5
aanvikm

Hello Sir, I can get this done. I would be using a program to do it. Thanks Aanvik

$176 AUD in 3 dias
(41 Comentários)
6.4
dgled

Hi, I’ve read your proposal regarding creating a database from CSV files by formulas or/and VBA. About me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced fo Mais

$250 AUD in 3 dias
(57 Comentários)
6.6
knikolovdev

Greetings, My name is Constantine, I'll be happy to make fast c# script to process the data and generate an output file. You can keep the scrip for reuse. Timeframe : less then one day. Looking forward, please check Mais

$100 AUD em 1 dia
(48 Comentários)
6.1
branislavm

Hi! Yes, most of this job can be done using formulas. Here is my offer! I can start immediately. Regards, Branislav Mihaljev

$164 AUD in 3 dias
(29 Comentários)
5.6
kh1604

Dear employer, good day to you. I have read your project [login to view URL] have checked the file. The file seems long so I will take help of programming to complete the task. To handover the task I will take 36 hours from Mais

$250 AUD em 1 dia
(17 Comentários)
4.4
antoinepal

Hello, I can make this csv for you as i have advanced excel skills. I will finish it in one day using formulas. Just give me the opportunity to show you what i can do. Thanks!

$235 AUD em 1 dia
(12 Comentários)
3.9