Transposing selected column headers

G

Guest

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.
 
S

Sharad Naik

It will be better if you attach the excel file
with an example of what you excactly want to do.

Sharad
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose selected column headings to rows 2
Transposing selected column headings 9
Auto Insert of Rows 2
Auto insert a number of rows 4
removing rows that have a blank column B only 1
Transposing a rng selected from a listbox 4
Sum Intermitten Data in one Column 5
Populating column N where is is blank or null 1

Top