I'm working a project with a large data set (>500,000 rows, 5 columns). The columns are the date, order number, invoice number, Amount A, and Amount B. There should only be ONE line for each invoice with both an Amount A and B. However, in some cases, the raw data has Amount A on one line and Amount B on the next line. The invoice column is merged.
There are also cases where multiple order numbers are on one invoice, so the amounts are broken out by order number when the goal is to have them summed for the invoice total. Again, the invoice cells are merged.
If I try to unmerge all of the cells, Excel crashes. Ideally, I'd like to unmerge the cells, but have the cell data copied to all new cells (so in the above example, I would unmerge the cell and 0041043 would appear in both new cells instead of just the top one). To my knowledge, that's not possible, but I'm hoping I'm wrong.