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.
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.
19 freelancers are bidding on average $11/hour for this job
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
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.