Merge a cells

Help Activities
, ,
1

Hi,
I have problem what kind of activities should be used to merge cells in excel in the below specific way.
I had pasted from Word the table to Excel in column A:D. After that was separate the value from column C to different cells (text to columns activity). Right now I would like to merge cells from column B with value from column F, G, H etc. as more as the data will be available (there won’t be value more than 10) but I need to merge in this way: B2&F2, B2&G2, B2H2, …, B3&F3, B3&G3, B3H3, …, B4&F4, B4&G4, B4H4 etc. and paste it to next sheet in workbook (as I show done manually on the second screenshot).

image
image796×193 4.54 KB

image

I try to Write Cell and in what to write I wrote formula “=CONCATENATE(E2,F2)” and any other combine but always I get the blank cells and the formula is visible for that cells.

2

Hi @Magdalena_Szella ,

The formula you have given Concatenate(E2,F2), has the E column values null.

This might be a possible cause for not getting the proper values concatenated

Regards,

3

Ohhh, I forgot write that to easy select the range I added activity copy/paste column and I copied column B to E.