Đã hoàn thành

Convert excel data in new excel data

We have an excel file with 439 rows of addresses. The columns are as followed:

- Company

- Salutation

- First Name

- Last Name

- Street

- Country Code

- Zip Code

- City

Task 1: Replace the Country Code by its full German country name.

Task 2: Convert one complete row so the columns are structed like this in one single cell:

- Company

- Salutation - First Name - Last Name

- Street

- Zip Code - City

- City

- Country Code (now Country)

Some rows won't have Salutation, First Name and Last Name. Then the structure should be:

- Company

- Street

- Zip Code - City

- City

- Country Code (now Country)

You probably will use VBA.

Kĩ năng: Excel VBA, Visual Basic, Excel

Xem nhiều hơn: excel macro move data existing cell, excel data validation empty cell 2007, excel script copy cell data closed file, excel convert to table shortcut, pivot table excel, excel convert table to list, convert table to text excel 2016, excel convert range to table, convert range of data to table excel, how to name a table in excel, how to turn an excel spreadsheet into a table in word, macro find data copy cell excel, macro excel copy existing cell data copy, convert microsoft sql data excel, convert oracle report data excel, convert excel data md5 encryption form, convert data word excel data, convert simply accounting data excel, convert excel data stata, convert excel data stata data

Về Bên Thuê:
( 13 nhận xét ) Götzis, Austria

ID dự án: #22262170

Được trao cho:

sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write Thêm

€30 EUR trong 1 ngày
(99 Đánh Giá)
6.1

99 freelancer đang chào giá trung bình €21 cho công việc này

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 (g Thêm

€50 EUR trong 1 ngày
(740 Nhận xét)
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

€35 EUR trong 1 ngày
(329 Nhận xét)
7.9
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can convert excel data in new excel data Thêm

€30 EUR trong 2 ngày
(326 Nhận xét)
7.9
FINGERRPRINT

Good in excel, Can split the data in respective column and get the clean excel with contacts. Thanks..

€30 EUR trong 1 ngày
(199 Nhận xét)
7.6
bouslimi1979

Hi, I ll code VBA and also some formula Just one question : do you have the list of codes and corresponding countries ? Or I have to search ? Thanks

€30 EUR trong 1 ngày
(283 Nhận xét)
7.7
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€30 EUR trong 1 ngày
(331 Nhận xét)
7.3
hdlong66

Hello, I can help to reformat 439 rows of addresses according to your requirements. I'm ready to start. Please drop a PM if you’re interested. Best regards, Hoang

€30 EUR trong 1 ngày
(138 Nhận xét)
6.8
ksriniravi

Greetings! I understand the requirements. I would write a small macro to convert the data in each row into a single cell. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel Thêm

€20 EUR trong 1 ngày
(197 Nhận xét)
6.9
tanjirdramatist

Dear Client, I have read your job description & have understood about your all requirements. I am an experienced person to do this kind of job. And also I have a big team to complete it earlier. After seeing my pr Thêm

€30 EUR trong 2 ngày
(160 Nhận xét)
6.6
oadsmedia

!!! Dear Honor !!! I'm interested in your project. Please send me a message so that we can discuss more......

€30 EUR trong 1 ngày
(77 Nhận xét)
6.5
vano101

Hello I have several years of experience with Excel Macros and Visual Basic I have checked project description and it looks as pretty easy to complete, perhaps, there is enough 1-2 hrs to finish

€17 EUR trong 1 ngày
(355 Nhận xét)
6.5
mtdevil369

Hi, I have understand the project requirement & interested to work for this project. I will complete it by 15 hours. Please send a message so we can discuss more & start the project. Thanks.

€19 EUR trong 1 ngày
(148 Nhận xét)
6.1
Nidhijain123

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work Thêm

€25 EUR trong 2 ngày
(101 Nhận xét)
6.2
zu02

Hi, there I hope all's well with you. I can code that row conversion using SQL/ADO/VBA coding within Excel. I'll detail in private chat. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here Thêm

€30 EUR trong 2 ngày
(33 Nhận xét)
5.8
vladimirmefremov

I am experienced in converting one sheet format into another using the concatenation of columns into one raw. The macro will be initiated from a button or action ikon.

€30 EUR trong 7 ngày
(8 Nhận xét)
5.5
uhjk

Hello, I can do this using php script. If you send me excel file I can convert it to format you want and send back. I can complete in <2 hours.

€30 EUR trong 1 ngày
(34 Nhận xét)
5.6
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. Thêm

€29 EUR trong 2 ngày
(45 Nhận xét)
5.6
markelof

It's a very easy task. I can finish it in a few hours. You will get structured data without any mistakes in it. Please contact me.

€15 EUR trong 1 ngày
(25 Nhận xét)
4.6
shahinrahimi

I have rich experience in VBA coding (API, Websacrping, Automation tasks, managing data, .....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfac Thêm

€20 EUR trong 1 ngày
(43 Nhận xét)
4.7
Stephenrajs

Hi there, I have a team. I Have 500 GB Internet With 20 Mbps Speed. I Have 6 Systems. I can do it. I have done many related projects like this. If you are provide this work, it will help my career also. Give me a c Thêm

€30 EUR trong 2 ngày
(92 Nhận xét)
4.9