Forum Discussion
Needing a format to merge cells
Hey guys, So Im currently trying to merge to cells that are in different columns. But they aren't keeping the numbers that Im needing them to keep when they merge. Is there a formula that Im com...
leighamarigoni If it's always a zero in one of the rows for a particular column, why not just sum the two? But, perhaps these numbers are in fact texts and then it doesn't make much sense, without a few extra steps. You haven't really explained how you are combining the rows for the other columns. Perhaps a workbook demonstrating a realistic data set and the formulae that you already have in place to combine the two rows would be helpful.