| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
Hybrid Mode
