I have info in col A thru H, but I need to have info in e,f,g to replace
b,c,d based on the answer in H which is yes. My next question is filtering,
how do I return the values that are in columns to rows?
Thanks

The first part of the question is not completely clear. With regards the
second part you asked how to return values in columns to rows? You can use
the Transpose feature ( see
http://www.auditexcel.co.za/lookupandreference.html ). Hope this helps.

"Rose Davis" wrote:

I have info in col A thru H, but I need to have info in e,f,g to replace
b,c,d based on the answer in H which is yes. My next question is filtering,
how do I return the values that are in columns to rows?
Thanks

Here is an example: for the first part,How do I replace b,c,d with e,f,g
based on the answer in H
A1 B1 C1 D1 E1
F1 G1 H1
F811 blank SCHOOL" 0.0 8999 TOP
plan Yes

"Adrian M" wrote in message
...
The first part of the question is not completely clear. With regards the
second part you asked how to return values in columns to rows? You can use
the Transpose feature ( see
http://www.auditexcel.co.za/lookupandreference.html ). Hope this helps.

"Rose Davis" wrote:

I have info in col A thru H, but I need to have info in e,f,g to replace
b,c,d based on the answer in H which is yes. My next question is
filtering,
how do I return the values that are in columns to rows?
Thanks