changing "vertical" data to "horizontal" data
Posted on 2012-04-11
I have a recurring problem that is difficult for me to explain, but here it is:
As an example, I have a database with one table that contains house addresses and another table that contains owners' names, usually more than one per address.
I want to convert this to one table, with the address in one field and the owners' names in subsequent fields, all in one record.
In the past, I've managed to do this (in most cases), but it involves a lot of manipulation of the data and setting up multiple queries, etc. It often takes a long time.
Is there a common/easier way to do this that anyone knows of? I typically use MS Access, Crystal Reports, and/or Excel to do my data gathering.
Hope this makes sense.