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).

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.