Forum Discussion
Concat Values In Same Column
Afternoon Excel Community, I'm currently trying to concat two cells in the same column (It's like this due to an output from a software where use). The column is formatted to where the cell below...
This has been slightly solved via another work around.
Highlighting the D1 and D2 and then using the fill handle makes it to where I can drag instead of copy and pasting.
I did try something using OFFSET but I couldn't get it to work: =CONCAT(OFFSET($B$1,*2,0), "|", OFFSET($B$2,*2,0))
Highlighting the D1 and D2 and then using the fill handle makes it to where I can drag instead of copy and pasting.
I did try something using OFFSET but I couldn't get it to work: =CONCAT(OFFSET($B$1,*2,0), "|", OFFSET($B$2,*2,0))
=CONCATENATE(INDEX(B:B,ROW($C$1)+(ROW(C1)-ROW($C$1))*2),"|",INDEX(B:B,ROW($C$2)+(ROW(C1)-ROW($C$1))*2))An alternative could be this formula.
- I actually got this concat to work using row nested within it.
=CONCAT(OFFSET($B$1,(ROW(B1)-1)*2,0), " | ", OFFSET($B$2,(ROW(B1)-1)*2,0))
Thank you for being my rubber ducky discussion board.
