I have bill of material where sometimes the "reference designators" are broken out in several rows of a column because there are so many. Is there a fast way using a macro or formula to take the individual rows in a column and move them to the first row in the column. I have enclosed "single line.xls showing before and after. Any help is alway greatly appreciated and thanks in advance for your help. Bob
Bookmarks