Excel Concatenate 60 Columns and then....

[GC1]

Hi,

I am looking to concatenate c60 columns of data and then drag it down the rows. I can concatenate with transpose to make this quick but i cant seem to be able to drag this down for the other rows?

Any ideas?

Many Thanks,

GC1

[Pete_UK]

Do you have the TEXTJOIN function in your version of Excel? That would make it a lot easier.

Pete

[GC1]

Hi,

Unfortunately not, is it an addin?

[Pete_UK]

No, it is part of Office 365 and (I think) XL2019 as a native function.

I seem to remember a function submitted by Tigeravatar some years ago called ConcatAll - maybe search this site to look for it.

Hope this helps.

Pete

[GC1]

Thanks Pete, I have transferred to another PC with 365 and go this to work.

Many Thanks

GC1

[Pete_UK]

Okay, well I found a reference to it in Post #18 of this thread:

https://www.excelforum.com/excel-for...reference.html

in case you (or anyone else) needs it in future.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete

[KOKOSEK]

I seem to remember a function submitted by Tigeravatar some years ago called ConcatAll - maybe search this site to look for it.

I've changed name to be more significant:

Please Login or Register  to view this content.