you mean to say combining F & G columns ? then use =F1&G1


On Oct 22, 1:46*am, ppeer wrote:
Hi Expert,

I have filled and blank cells in columns F and G.
Columns B:E are blank. A is filled.
I would like to put the F and G cells, if filled, to column B.
Any suggestions?

Now:

b *g
b *g
b
b *g
bf
b
bf
bf

Desired:
bg
bg
b
bg
bf
b
bf
bf