Completed

Excel macro for merging rows

I need a short macro to merge columns.

The basis is a table (with variable size in rows and columns).

For a column that I want to be able to select freely, I want to merge rows for column content that occurs several times.

Let's say I select column D from a table with columns A:F. In the rows in this column, some cells have the same content, but the same or different content in the cells in columns A:C and E:F. Then I want to be able to merge the table in a way so that the content in the cells from column D occurs only once. This means that the content of the columns A:C and E:F needs to be merged in a way that this what has been written in independent cells is combined in one cell, and for each row that has been merged is separated by alt+enter.

Please see the sample file attached which describes another example.

Note:

The data usually has a first row with descriptions.

The table is variable in size and I would like to define the table size in the macro myself.

I want to freely select the column to merge.

I don't need any entry windows, just plain code with short comments where to make changes (selecting the column for merging and defining table size).

In case of any questions, please drop me a line.

Only freelancers are considered who give an estimate of the time they need for completing the macro and a day when they will have finished it.

Skills: Excel, Visual Basic

See more: macro excel merging rows, excel macro merge rows, macro merge rows, macro freelancers, freelancers for code, freelancers excel, for several times, define data entry, code for me freelancers, what is macro in excel, rows, macro e, completing the case, excel row column, excel macro row, sample visual basic excel, excel 2014 macro, excel column row, excel sample file, column row excel

About the Employer:
( 65 reviews ) Leipzig, Germany

Project ID: #5355979

Awarded to:

Migul86

Hi, This would be stright forward in my opinion. I would require 30 mins to make it work on any data set, the merging could also encmpass characters such as semicolons to convert to other formats. Here's a two li More

$5 USD / hour
(2 Reviews)
0.0

19 freelancers are bidding on average $11/hour for this job

jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche More

$7 USD / hour
(514 Reviews)
8.0
zExcel

Hi, my bid is not on hourly rate basis. Will do the job in 2 hours (if you can award soon) for a flat fee of $40

$8 USD / hour
(254 Reviews)
7.6
maverick44000

Hi CS. I am Usman and being highly proficient in VB macro's, I can write the desired macro for you in 2 hours at my quoted rate. I shall not charge you anything extra, if the work takes any longer than 2 hours. I shall More

$20 USD / hour
(85 Reviews)
6.9
paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-e More

$10 USD / hour
(121 Reviews)
6.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$7 USD / hour
(117 Reviews)
6.3
djain01

Hi, You have attached an empty excel file. Please send the file with data samples. Please check my reviews for more details of my work quality. Thanks Dhirendra Jain

$11 USD / hour
(52 Reviews)
5.4
abhinovpankaj

Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. More

$7 USD / hour
(44 Reviews)
5.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than More

$8 USD / hour
(42 Reviews)
5.6
BDtW

Hello Thank you for explaining the project so elaborately. I believe I can do the work for you in 3 hours. Actually It should be OK within 2 hours , but I have kept that extra hour for communicating with you and del More

$6 USD / hour
(33 Reviews)
5.1
srdas2012

Hi, We are Expert in Excel Macro VBA/VB6/VB.Net can bring almost VB6 in Excel [login to view URL] would like to do this Macro for you. We have delivered the following similar projects in Freelancer:- [login to view URL]://[login to view URL] More

$5 USD / hour
(23 Reviews)
4.8
Baxter2008

Hello I am an Excel VBA developer. I would like to put in a bid on your project, but have a few questions about what you require. The example workbook that was attached to the project is empty. If you can provide t More

$10 USD / hour
(24 Reviews)
4.1
JMMachado

Hello! I can help you... I have more than 19 years of excel experience. I'm ready to put all of that at your disposal. Thank you.

$10 USD / hour
(2 Reviews)
3.0
vkpajeet

hello sir warm greetings. I'm good at excel vba. kindly check my employers review in my profile. Will be able to finish this in the next 12 hours. and willing to charge you $30. kindly pm to dicuss furt More

$5 USD / hour
(6 Reviews)
2.6
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

$30 USD / hour
(2 Reviews)
2.3
solution4you

Aucune proposition n'a encore été fournie.

$5 USD / hour
(4 Reviews)
2.6
aceless

Are you shure you want to work with a macro? I can make/explain you how to do that with formulas. This will be much more robuster, ad you will see what exaclty is being combiend.

$33 USD / hour
(0 Reviews)
0.0
willoughby01

A proposal has not yet been provided

$4 USD / hour
(0 Reviews)
0.0
JobSteve

A proposal has not yet been provided

$11 USD / hour
(0 Reviews)
0.0