Merge First Column of Data to Create a Grouping of Subdata

[Jordan Ansley]

I have a set of data in a column consisting of a material listed with a corresponding subset of data listed in the next column.



These subsets vary in dimension and I would like to merge the values in the first column so that there will be one preceding cell for each matching subset of corresponding data.



The VBA script that I am working on is already confusing and this is confusing me even more. I cannot figure out how to obtain an automatic loop that will find where the next row has a value, then merge and so forth.... Please Help. Thanks.

 

[hiker95]

Jordan Ansley,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


Screenshots will probably not work correctly because of the merged cells.

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed


mark the workbook for sharing

and provide us with a link to your workbook.


3. And, can we see your present macro code?

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]