I have a table built like this:
Name | Benefit | Price | Level
Bob | Health | $10 | Employee
Bob | Dental | $5 | Employee+Children
Suzie | Health | $9 | Employee
John | Vision | $2 | Employee
John | Term Life| $0 | Employee
John | Medical | $9 | Employee
I want a table like this (one row as an example, but for all records)
Name | Medical | Medical Price | Medical Level | Dental | Dental Price | Dental Level | Vision | Vision Price | Vision Level |
John | Medical | $9 | Employee | | | | Vision | $2 | Employee |
Looking for any help - I'm pretty new to SQL or the query builder (and access as a whole), so any assistance would be greatly appreciated!