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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing selected column headers
It will be better if you attach the excel file
with an example of what you excactly want to do. Sharad "Gar3th" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing selected column headers
Hi
I'm a bit new at this and cannot see how to attach an example to my question as this is what I intended to do. If you can explain how I'll do it. Regards Gareth "Sharad Naik" wrote: It will be better if you attach the excel file with an example of what you excactly want to do. Sharad "Gar3th" wrote in message ... 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. |
Reply |
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 |