I have a Pivote table on sheet1 as follow:

Column A ColumnB
Product Type
a 1
3
4
b 6
9
f 10
15
The column A show a lot of products with diferent types on column b, the
types can be only 10 different types
On sheet2 I need show all values displayed in sheet1 for the Product that I
select on sheet2 I have 10 spaces between each product
For example:
If I select on Sheet2 product "b" and "f" need show the follow:
In write in A1 "b" need show:
ColumnA ColumnB
b 6
9
the 8 spaces after I write in A11 "b" need show:
f 10
15

I will appreciate your help a lot have 7 months traying to found how can do
that
Regards