I have a table where users will input daily values for set of ID tags. The table is structured like this:
DATE ID VALUE 1-1-2020 A 1 1-1-2020 B 2 1-1-2020 C 3 1-2-2020 A 4 1-2-2020 B 5 1-2-2020 C 6
For other users to work with data easier, they would like a query that would have the ID tags as the column headers and the date column remains, structured like this:
DATE A B C 1-1-2020 1 2 3 1-2-2020 4 5 6
Is it possible to create a query that can do this for me?
Thanks for any help or point in the right direction. First post, happy to join a great community.