Converting columns to rows for multiple rows

Hello,

I have about 700 rows of 14 columns. Row 1, the header, needs to repeat down column A, not to hard, I could just copy and paste doubling each time, tedious, but...

The data in rows below the header needs to fill in column B. When done, its over 7000 rows in 2 columns. (it then gets imported into a DB through a transform map over which i have no input or control).

I got here as, I need to convert from this format to the 700x14 and I use OFFSET to do it. Works pretty good. Is it possible to go the other way? I saw a solution using INDEX, but it is for just one row, I have 700, and do not really want to repeat it manually.

I apologize if the solution is already on the board, I'm just not using the right search phrase if it is.

TIA

What I believe you are trying to do is a reverse pivot. Here are the steps:

http://spreadsheetpage.com/index.php...summary_table/

Note: If you are using Excel 2007 or above, you will need to key Alt, D, P to get to the old pivot table wizard. You will also want to ID your rows before performing the reverse pivot. Simply insert a new column A and label your rows 1-n.