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