Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing selected column headers
Hi
In Excel 2000 I have a spreadsheet with a list of staff names in column A. Columns B to P are head with different item types for which they . Under these headers is either a value or text entry. I have inserted a blank row for each header that contains an entry other than 0 or "N". Now I want to place the headers, where the entry is anything but 0 and 'N', in the blank rows starting in the next column ie Q so its a form of transposition. However the number of blank rows is different for each staff member. I will be extremely grateful if anyone can supply a solution. Regards Gareth PS If Edwin Tam sees this it is a follow on from the auto insert you provide which has worked beautifully. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
How to: Change color of column / row headers and selected menus? | Excel Discussion (Misc queries) | |||
Can I change Headers and footers in selected Reports at the same . | Excel Discussion (Misc queries) | |||
Transposing a rng selected from a listbox | Excel Programming | |||
Transposing one column into three | Excel Programming |