Concatenate cells, replacing blanks with cell contents from other
On 21 feb, 15:53, Martin Fishlock
wrote:
Hans,
I need to use two extra columns:
in e2 put =if(b2="",e1,b2)
in f2 put =if(c2="",f1,c2)
in e1 put =b1
in f1 put =c1
in a1 put e1&f1&d1
then copy down
then copy down
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
" 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- Tekst uit oorspronkelijk bericht niet weergeven -
- Tekst uit oorspronkelijk bericht weergeven -
Martin,
I came up with the same solution, but please look at Ron's solution,
no extra colums needed!
Anyhow, thanks for your help.
Hans
|