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!