Converting column data into rows

Ray789,

In the "Outcome" section, do you have a column already populated? or is this being built from scratch? Does each owner only have 1 column B Make? (as in the example, each owner has only one column B make, though the dolumn D make varies).

If the table is being built from scratch and you need a unique list of owners, you can do the following to extract the list of owners with no duplicates:

1. Select column A
2. Data -> Advanced Filter
3. Select "Copy to another location"
4. Make sure the list range contains only column A from the header to the last row (sometimes the advanced filter auto-populator can be on the stupid side and will populate the list range with columns you don't have selected)
5. Set the Copy to to a blank column
6. Check "Unique records only" -> OK

That will generate a list of owners with no duplicates. Then you can use that list of owners to populate the table:

To pull the Column B make (again, this assumes there is only 1 column B make per owner):
=VLOOKUP(O3,A:D,2,FALSE)

To get the number of Column D makes per owner, since you're using 2007 you can use CountIfs:
=COUNTIFS(D:D,"Audi",A:A,"Mark")

And so on. You would replace "Mark" with the cell containing the Mark in the unique list of names. For example, had you set the Copy To to column F, and Mark was in row 2, then you would replace the "Mark" with F2