Hello Everybody,
How to make a column as column header and another column as row header in access. I have attached sample.png. I wanted to take Divisions as Column header and Categories as row headers and color as the data. Below is the sample output that I need:
Catogery Division1 Division2 Division3
Category1 Red Yellow Green
Category2 Yellow Red Red
Category3 Green Red Yellow