On 21 feb, 10:34, "Pete_UK" wrote:
I assume column A is currently empty. Position the cursor in B2 then
press F5 (Goto), then click Special and Current Region. Then press F5
again, Special and Blanks. This should have highlighted all the cells
which are blank in columns B and C, with B2 being the active cell.
Then enter an equals sign, click on cell B1 then CTRL-ENTER, and all
the blanks will be filled with a formula to take the value immediately
above it.

You can then enter:

=B1&C1&D1

in cell A1 and copy this down for as much data as you have.

Hope this helps.

Pete

On Feb 21, 9:02 am, 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 -

Thanks for the advise,
The problem is that columns B to D are part of a pivot table, so I
cannot fill them in that way.

Regards,
Hans