How to unmerge and fill in identical values
Posted on 2011-09-24
I was wondering if there's an easy way to do this. I have a spreadsheet with about 8,000 rows. It is supposed to be something like this (please disregard all except the first column)
1 a a x x
1 b a x z
1 c a a z
2 a s d z
2 k a z c
but it was entered in such a way that Cells A1-A3 where merged and centered with just one entry of 1, and Cells A4-A5 were merged/centered with one value of 2. There are almost 8000 such rows, and identical / repeats in the first column are different (e.g. in the example above there are three 1s but just two 2s. Each of this "grouping" variable can be as many as 100 rows, or as few as just one row.
Can someone show me what's an efficient way of Unmerge this and turn it into the format shown above (i.e. no merged cells)?