How to copy cell location

[Legacy 185509]

I have cells going from
B1 and skips column so it goes like
B1___D1___F1____H1____J1____L1___IL1(iL1)

I need to copy all this location in this format
B1:B1
if not possible B1 through IL1 is also find I can take on from there

Thank you

 

[Robert Mika]

Can you elaorate your question a little bit?
Do you want to copy only notblank cells?

 

[Legacy 185509]

yes I just want to copy the location like whole column of B then skip one column than copy whole column of D and so on till IL

so it would be like
B:B,D:D,F:F,H:H and so on it IL:IL