textjoin

How to Textjoin on resetting row number


Im trying to use the textjoin function in excel. i want to merge the text if column A is same and column B is same, then it should merge column G with an resetting counter on column E.

I hope the picture describes it more clearly

enter image description here


Solution

  • If you need more than two rows to be concantenated you can use a helper column like this:

    Result:

    enter image description here

    If you have a non-english version of Excel you will have to translate the function names IF and AND accordingly.