How to Convert a Normal Query to a Crosstab Query in Access

https://www.microsoft.com/en-us/videoplayer/embed/RWejjl?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_convert_a_normal_query_to_a_crosstab_query_in_access_2016.cfm

"Turn a select query into a crosstab query for a more readable set of results.

Sometimes a normal (select) query will return results, where, some fields need to be duplicated in order to show all the data.

A crosstab query allows you to group the query results in a way that removes the duplicate values, and presents the results in a way that makes them easier to read and decipher."