Excel report / VBA - Help.

[S.KARTHICK7]

Hi all,
Hope all is well at your end.

I am wondering if any of you guys can help me out with the problem and example given below.

For eg.
in excel sheet, lets say Data contains quantity of five products available in each store.
`````````A B C D E
Product A 12 12-24 12
Product B---20
Product C 24 24 20-24


But I want another sheet to show the report like storewise as mention below

` Store no. A,B & E
` Product A 12
` Product B 24

` Store no. C
` Product B 20
` Product C 20

` Store no. D
` Product A 24

hope you could understand my problem.
Looking forward to hear from you guys soon.

Many thanks in advance.
Cheers,
Karthick