Using MS 365 Excel on Mac. I need to merge about 500 rows (out of 1200+), each with 10 columns containing both duplicate and non-duplicate data - including blank cells - into 250 single rows so that these 'new' rows have all the data from both. Any suggestions welcome, thanks!
