Matrix report

[elsepulse]

Hi,

Please have a look at the attached excel file for the data.

Always COL-G will have some data.

Can any one help me how to generate required report.

Thanks in advance.

[barryleajo]

Hi elsepulse
Welcome to the forum.
I have attached your file which answers your very specific problem.
I have not given thought to error checking or scaling up the problem to a larger table.
Should get you going though.
Good luck
barry

[elsepulse]

Hi Barry,

Thank you for your great help. I will go ahead as my requirement.

Jake