Dears,

I have a table with data spread in various columns. These data are "industry name" linked to a business opportunity

For example:

- Line 1 corresponding to business opportunity A, i can have the data "transformers" in column M

- Line 2 corresponding to business opportunity B, I could find this same data "transformer" in column N

- Line 3, corresponding to business opportunity C,  this data "transformer will not appear" but other industry name such as "cable" will appear.

Please find screen shot here below.

I would like to be able to generate reports based on Industries name and select it on a graph. For example, create a graph  giving me the number of of opportunities including "transformers" AND "Instrument Transformer".

Is there a simple way to do this ?

Thank you very much

Alexandre