Row to Column
 

I need to take the headings from a sheet and create a row for each heading.

How can I do this programatically or using a formula. Each heading will be
a row. I should return somewhere around 432 rows when complete.

Row to Column
 

Hi,
Highlight the headings, copy, go to the cell where you want to copy, paste
special, transpose

"DrewBe" wrote:

I need to take the headings from a sheet and create a row for each heading.

How can I do this programatically or using a formula. Each heading will be
a row. I should return somewhere around 432 rows when complete.

Row to Column
 

Try the following formula

=INDEX($C$2:$F$2,ROW()-ROW($H$2)+1)

Replace c2 with the first header (i.e. $A$1) and f2 with the last header.
H2 is the first row for your first header. Be sure to make it absolute just
like the example.

"DrewBe" wrote:

I need to take the headings from a sheet and create a row for each heading.

How can I do this programatically or using a formula. Each heading will be
a row. I should return somewhere around 432 rows when complete.

Row to Column
 

I don't neccessarily want to do this for 432 seperate times. Can I do this
once then drag this to Autofill?

"Eduardo" wrote:

Hi,
Highlight the headings, copy, go to the cell where you want to copy, paste
special, transpose

"DrewBe" wrote:

I need to take the headings from a sheet and create a row for each heading.

How can I do this programatically or using a formula. Each heading will be
a row. I should return somewhere around 432 rows when complete.