Concatenate range of column values in a row

  • I've 144 or so columns of potential data that I want to concatenate in the attached file.
    forum.ozgrid.com/index.php?attachment/72293/


    Some rows have only 1 item to concatenate but others have up to 17.


    I'd like to avoid having to write out:
    =concatenate(b2,",",b3,",",b4,",", etc..... to eq2) as a formula.


    Most bits I found on line use concatenate with a transpose but I'm not transposing data.


    I tried =CONCATENATE((B2:EQ2)&",") but got a #Value.


    Thanks for any help!

  • Re: Concatenate range of column values in a row


    Which version of Excel do you have?

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Concatenate range of column values in a row


    No, the 365 subscription has TEXTJOIN. ;)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Concatenate range of column values in a row


    I found a solution using a function:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!