Kutools For Excel ((free)) -

He checked "Merge data by row headers." He hit .

"Consolidate these by morning," his manager, the perpetually stressed Mr. Henderson, barked, dropping a stack of USB drives and a printed list of server paths. "We need to merge the Q3 data from all twenty regional branches. And clean up the duplicates. And merge the cells for the header formatting. And for the love of Wall Street, fix the casing on the names. They’re a mess." kutools for excel