Join Formula from Reference Sheet
I am trying to use Join Formula to concatenate 2 adjacent cells from different columns of another sheet. It returns the value correctly actually, however, as I am trying to drag the formula down, it doesn't work anymore unless I specifically edit again the formula in each cell which is impractical as I have more than a thousand entries to join.
I tried adding $ everywhere but did not work too😆
Help Article Resources
Check out the Formula Handbook template!