Завершено

Excel Data Merge in a Specific Format

Please see the attached file, this should be a simple job for someone who knows what they are doing.

Basically, for each SKU, using ‘PPGC00005’ as an example. Would need to change:-

PPGC00005 1 Name On Front 12 1

PPGC00005 2 Message On Front 20 1

PPGC00005 3 Message Line 1 Inside 20 0

PPGC00005 4 Message Line 2 Inside 20 0

PPGC00005 5 Message Line 3 Inside 20 0

PPGC00005 6 Message Line 4 Inside 20 0

PPGC00005 7 Message Line 5 Inside 20 0

to:-

PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005

1|2|3|4|5|6|7

Name On Front|Message On Front|Message Line 1 Inside|Message Line 2 Inside|Message Line 3 Inside|Message Line 4 Inside|Message Line 5 Inside

12|20|20|20|20|20|20

1|1|5|5|5|5|5

So column A1 would be:-

PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005

1|2|3|4|5|6|7

column A2:-

Name On Front|Message On Front|Message Line 1 Inside|Message Line 2 Inside|Message Line 3 Inside|Message Line 4 Inside|Message Line 5 Inside

and so on...

In the Excel there is around 20,000 records, but yeah we’re basically combining the column separated by |

For each SKU if that makes sense

o we will still have 5 columns, A - E, just a lot less rows as each row will be a unique SKU

Квалификация: Ввод данных, Обработка данных, Excel, Visual Basic, Word

Показать больше 1. Please use Decision 4 results for your company in Stratsim. 2. Remember, the answer isn’t as important as demonstrating a c, please attached file, excel data merge script indesign, mail merge labels, mail merge word 2016, mail merge excel to outlook, mail merge from excel to excel, mail merge word 2010, mail merge excel, mail merge from excel to word labels, mail merge in excel without word, data entry, data processing, visual basic for apps, microsoft excel, excel sort text specific format, excel data refresh lock format, excel data converted address format, excel data format add net, automatically format excel data word template

О работодателе:
( 20 отзыв(-а, -ов) ) Ibstock, United Kingdom

ID проекта: #17216458

Поручен:

sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Больше

£10 GBP за 1 день
(82 отзывов(-а))
5.3

35 фрилансеров(-а) в среднем готовы выполнить эту работу за £18

FINGERRPRINT

yes we can do it.. but the the result will be in 1 row.. is that correct. we can get you the output. the single grid will not accept 20,000 records, we can separate 5000 each for 4 rows

£20 GBP за 1 день
(326 отзывов(-а))
8.0
RSUKANTA2014

Hello, I just checked the .csv file and very much interested to do this work. I want to do this task manually without using any software because I want to provide you a good quality work. With software there will be a Больше

£20 GBP за 1 день
(356 отзывов(-а))
7.2
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can automate this for you. If you are interested feel free to message me. I've completed many similar projects and i've never had a single problem. B Больше

£18 GBP за 0 дней(-я)
(427 отзывов(-а))
6.8
customizedata

I have downloaded the attached file,but it is a csv and not an excel file so we can not directly put excel VBA over it. 1- i can easily write a code to the merging as described 2-Column A1 to A5 will be delivered Больше

£20 GBP за 1 день
(107 отзывов(-а))
6.1
liangjongai

I can work for you. I'm interested in your project. I've an experience of works with ms excel and vba. Ping me any time to discuss about this project.

£18 GBP за 1 день
(11 отзывов(-а))
5.2
£20 GBP за 2 дней(-я)
(58 отзывов(-а))
5.2
Ruchiagarwall

Hello sir, I am ready to do this project. If u give me one chance to show my quality work then i will be greatfull. For more information about me, Please check my profile and reviews. Thanks Ruchi

£23 GBP за 3 дней(-я)
(26 отзывов(-а))
5.1
antoinepal

I am an experienced Data Analyst with advanced skills in Excel. I have done a lot of projects like this one in the past for various companies and i have over 8 years experience in the field. I would be glad if you gi Больше

£20 GBP за 1 день
(19 отзывов(-а))
4.8
JackieXu

hello. how are you? i have read the description of this project. i think this work prefer for me because i did some work like this project before. i can do this work in short time. kind regard.

£18 GBP за 1 день
(35 отзывов(-а))
4.9
sevillajk01

hi! I can help you with your project. Maybe its better to use publisher than the word. anyway you will be the one to decide. thanks

£15 GBP за 1 день
(15 отзывов(-а))
4.0
rIbrarahmed

hi, I am very good in excel vba, macro. if you want to see my skills on excel I will share with you some of my stuff. I feel fit for the project. please contact with me. thanks

£18 GBP за 1 день
(17 отзывов(-а))
4.2
Mfaisalshahzad00

Hi, It is possible to do so. I can do it for you immediately. I am expert in Excel having 12 years Professional experience in it. I’ll complete task with 100% Accuracy and in least possible time. I assure y Больше

£18 GBP за 1 день
(19 отзывов(-а))
4.0
£18 GBP за 1 день
(14 отзывов(-а))
3.8
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, formatting, macros, etc. thanks

£28 GBP за 1 день
(15 отзывов(-а))
3.6
skywa1kervw

I can do this in one day with a small program that takes your file as input and outputs another file in the format you have described in your details. If you like the output, we can give you the program for little extr Больше

£18 GBP за 1 день
(3 отзывов(-а))
3.3
ttomekk

Hello, I will be happy to deal with this project. I have a lot of experience in this type of projects. Regards, Tomasz Pawlak

£18 GBP за 2 дней(-я)
(1 отзыв)
2.1
£18 GBP за 1 день
(2 отзывов(-а))
1.0
sandyfor80

Hi Dear, I am professional at excel and have good experience. I don't have any ongoing projects right now.. so your work will be priority for me.. I will finish your job as fast as possible. Thanks

£18 GBP за 1 день
(1 отзыв)
1.2
noshinnur1

Hello. I can get it done for you within a couple hours. Please let me know if you are interested. Thank you. [login to view URL] P.S. I have done the first one and sent you the file, please check if this is what you are looki Больше

£18 GBP за 1 день
(2 отзывов(-а))
0.9
kerolos182

I download your file and I can finish your work fast and high accueratly .because I have experience in excel

£10 GBP за 1 день
(0 отзывов(-а))
0.0