Pull out unique values based on filters/relationships

[excel4phil]

I have a table like this:

Category 1	Category 1 Topic 1
Category 1	Category 1 Topic 1
Category 1	Category 1 Topic 2
Category 1	Category 1 Topic 2
Category 2	Category 2 Topic 1
Category 2	Category 2 Topic 2
Category 3	Category 3 Topic 1
Category 3	Category 3 Topic 2
Category 3	Category 3 Topic 3

What I'd like is a list like this:

Category 1
	Category 1 Topic 1
	Category 1 Topic 2
Category 2
	Category 2 Topic 1
	Category 2 Topic 2
Category 3
	Category 3 Topic 1
	Category 3 Topic 2
	Category 3 Topic 3

I'm trying to pull each Category once out into 1 column, and each of it's Topics once in another column.

[AlKey]

Please see attached file with PivotTable solution

[alansidman]

Look at this

http://office.microsoft.com/en-us/ex...003073425.aspx

[newdoverman]

Your desired solution looks like a Pivot Table solution to me.

[excel4phil]

Please see attached file with PivotTable solution

Works great, thank you!!!

[AlKey]

You're welcome and thank you for your feedback! Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).