Forum Discussion
merge to values in one cell
hi team, I want to ask that I have data in excel in different cell, and I want to merge two values in one cell. from example; value Should be like this 12000 12001 1 13000 1300...
One more
=IF(ROW()=1,B$2&B$3,
IF(INDEX(C:C,ROW()-1)=INDEX(B:B,ROW()-1)&INDEX(B:B,ROW()),
"",
INDEX(B:B,ROW())&INDEX(B:B,ROW()+1)
)
)