Access Query- Transpose
Posted on 2016-10-31
I have a table that has data residing in columnar format. i.e, we have an individual in one row, and their dependents in subsequent rows below it; however, there is a key field that links the dependents to the parent. I need to change the layout of this table to list the dependents in the same row as the parent. Is there an effective way that I can transpose the table from being vertical with the parent and dependents to being horizontal?