Help splitting merged cell and filling new cells...

[John]

I need to split a varied number of merged cells into rows and then
fill those new rows with the original data. (Lots of rows...)

Example:
A5:A7 contains "Student Name"
B5 = Math
B6 = Spelling
B7 = History
C5 = 90
C6 = 95
C7 = 80

Sometimes, the merged "A5:A7" range contains more rows, sometimes
fewer. I need to split that range into A5 = Student A, A6= Student A,
and A7= Student A. (This isn't the actual data, just an example of
what I need to do.)

Any help is greatly appreciated!

 

[Andy Brown]

Are there any actual blank rows (as opposed to blank cells in column A)?

Seems that if A5:A7 is merged, then when you unmerge the text ends up in A5
(whether the original text was in A5, A6 or A7). Maybe you could try this
....

Select the whole range of merged cells in column A and unmerge. F5 --
Special -- Blanks -- OK. Press the "=" sign, click on the top cell (A5 in
your example), press CRL+Enter. Copy and Paste Special (Values) the range to
clean up.

HTH,
Andy