Can this data be presented in a 'nicer' way?

[AlbertKJ]

I have a list of companies (600) with a selection of the products they stock. The number of products amounts to 20. If a company stocks a particular product, I enter a 'Y' in the column. If the company does not stock a product, I enter a 'N' in the relevant column.

So my sheet looks like this:

Column A	Column B	Column C	Column D	Column E	Column F
Name	Address	Phone	Email	Product 1	Product 2
ABC Ltd	1 Main St	123456789	abcltd@abcltd.com	Y	N
XYZ Ltd	2 Main St	987654321	xyzltd@xyzltd.com	N	Y

<tbody>
</tbody>

Is there a better way to present this? It seems a little awkward and clunky. The fact that I need to scroll across to see everything is annoying (20 products causing this). Would prefer not to use VBA.

Would appreciate any tips to improve on the above, thanks!

 

[ArthriticPanda]

Hi Albert,

I would go with a pivot table. Once you've entered the data, you can pivot it to a view that suits and then apply a nice format to it using standard formats.

AP