I have a sheet that looks like this:
A | B | C | D | E |
----------------------------------------
62| Value1| Value2| | |
345| Value3| Value4| Value5| Value6|
17| Value7| | | |
111| Value8| Value9| ValueA| |
I'd like to transform it to this:
A | B |
----------------
62| Value1|
62| Value2|
345| Value3|
345| Value4|
345| Value5|
345| Value6|
17| Value7|
111| Value8|
111| Value9|
111| ValueA|
This seems like a common enough procedure (I'm normalizing a table) that Excel would have this canned. Is there an easy way to do this, or does it get down to writing a macro or VBA?