Hi all,

I have a large spreadsheet with 16000+ rows of data in it. It has some duplicates and some single entries.

I have 60 columns and I need to concatenate the values of the 60 columns where the values of "Column 1" are the same.

Ideally I would like the script to subcequently delete the blank rows leaving me just the concatenated data and the single entry data.

I have tried a number of scripts that I found online but none seem to have the desired outcome, can anyone help please?

Many thanks