Help require to merge the columns

[mso3]

Hi friends,

The code is working fine but only for column ‘bf:bg’ it’s not working.

If there is no value in the columns "j8:j82,p8:p82,v8:v82,ab8:ab82,ah8:ah82,an8:an82,at8:at82,az8:az82,bg8:bg82,bj8:bj82" then I want to merge the columns "I8:j82,o8:p82,u8:v82,aa8:ab82,ag8:ah82,am8:an82,as8:at82,ay8:az82,bf8:bg82,bi8:bj82".

Please see the workbook for detail information and reference.

Any help will be highly appreciated.

Thanking you.

[JasperD]

It's cause you have 6 columns between s8 and s9 and only 5 between s1 - s2 - s3 - s4 - s5 - s6 - s7 and s8
Since your code goes through the columns with step 2, messing this up means that your code will not understand that column.

Move the data from column BF to BE and you're set.

[mso3]

Thank you. Now it's working fine.