Concatenate cells, replacing blanks with cell contents from other
The formula below placed in column A Give what you want. If you follow this
logic down column A then it should solve your problem
=CONCATENATE(B1,C1,D1)
=CONCATENATE(B1,C1,D2)
=CONCATENATE(B1,C1,D3)
A B C D
M1K011 M1 K01 1
M1K012 2
M1K013 3
" wrote:
Is it possible to solve this with only formulas, no coding?
data is organized in this way:
B C D
M1 K01 1
2
3
K02 1
2
3
M2 K07 1
2
3
In column A I need
M1K011
M1K012
M1K013
M1K021
....
The answer is probably outthere somewhere, but I have no clue on how
to look for it.
Thanks in advance,
Hans
|