Columns to be merged if value is same ( duplicated )

Hi krjoshi

Try the code below which is being applied to row 3

Please Login or Register  to view this content.

Hi Joshi

In the line of code below


For Each xC In xOutput.Range(xOutput.Cells(3, 6), xOutput.Cells(3, x))

Change the 3 to 2, so it becomes


For Each xC In xOutput.Range(xOutput.Cells(2, 6), xOutput.Cells(2, x))

And rerun and it would apply to row 2