i have this data :

A B C
1 ID Summer Fruit Date Quantity(kg)
2 1 watermelon /4/9 20
3 2 pear /4/11 13
4 3 peach /4/13 50
4 4 peach /4/14 24
5 5 pear /4/16 70
6 6 graps /4/15 80
7 ID Winter Fruit Date Quantity(kg)
8 1 orange /10/12 45
9 2 graps /10/14 50
10 3 graps /10/15 70
11 4 orange /10/12 45
12 5 quince /10/14 35


when use filter in this list for "graps" , i want to fix both 1 and 7 rows
as headers and not to be hide in any case, any help considerated

You should have all the data under one row of headers. You should add a
column as to whether it is SUMMER or WINTER fruit.
--
John C


"gr_jafari" wrote:

i have this data :

A B C
1 ID Summer Fruit Date Quantity(kg)
2 1 watermelon /4/9 20
3 2 pear /4/11 13
4 3 peach /4/13 50
4 4 peach /4/14 24
5 5 pear /4/16 70
6 6 graps /4/15 80
7 ID Winter Fruit Date Quantity(kg)
8 1 orange /10/12 45
9 2 graps /10/14 50
10 3 graps /10/15 70
11 4 orange /10/12 45
12 5 quince /10/14 35


when use filter in this list for "graps" , i want to fix both 1 and 7 rows
as headers and not to be hide in any case, any help considerated

Dear John C
many thanks

"gr_jafari" wrote:

i have this data :

A B C
1 ID Summer Fruit Date Quantity(kg)
2 1 watermelon /4/9 20
3 2 pear /4/11 13
4 3 peach /4/13 50
4 4 peach /4/14 24
5 5 pear /4/16 70
6 6 graps /4/15 80
7 ID Winter Fruit Date Quantity(kg)
8 1 orange /10/12 45
9 2 graps /10/14 50
10 3 graps /10/15 70
11 4 orange /10/12 45
12 5 quince /10/14 35


when use filter in this list for "graps" , i want to fix both 1 and 7 rows
as headers and not to be hide in any case, any help considerated