| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeating Column header for each row
jamex,
you can do it with formulas. Assuming your data (first header, NAME) starts at A1, and assuming that your output starts at E1, you can use the following formula in E1: =IF(MOD(ROW()-ROW(E$1),2)=0,A$1,OFFSET(A$1,1+(ROW()-ROW(E$1))/2,0)) This formula can be copied down and to the right, as far as necessary. Replace A1 and E1 to suit. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Find the first Value in a Row and Retrieve the Header for That Column | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Threaded Mode
