Insert Columns in between each column containing data
Sub InsertColumns()
Range("B1").Select
Do Until ActiveCell.Value = ""
Selection.EntireColumn.Insert
ActiveCell.Offset(0, 2).Select
Loop
End Sub
Delete Columns in between columns containing data
Sub DeleteColumns()
Range("B1").Select
Do Until ActiveCell.Offset(0, 1).Value = ""
Selection.EntireColumn.Delete
ActiveCell.Offset(0, 1).Select
Loop
End Sub