0

I want to create a pivot table, query in access(office365) like the one I made in xlxs(see image). The table with data is very straightforward, with 3 columns of data.

The table with data

The pivot table The pivot table

Now I would like to have the same pivot table (lay-out) in access, but I can't find the solution. Pivot tables ain't what they were. This is how far I got.

design view pivot

view pivot

Please help.

I tried a lot of things but can't find the solution.

Vahit Keskin
  • 274
  • 1
  • 9
Paul
  • 11
  • 2
  • Looking at the first two images, it would appear that you just need to transpose the table. If that's the case, [this](https://stackoverflow.com/a/13377114) might help. – FiddlingAway Jan 22 '23 at 13:42

0 Answers0