Not sure how well I've described that in the title, but I'll do my best to explain what I'm looking to do!

I basically have a table based on a query based on two linked tables in Access.

So 1 table for 'Features' :

FeatureID
Feature
Description
etc

and 1 table for 'Categories' :

FeatureID
Category


In a one-to-many relationship.

So the resulting query table looks like :

FeatureID, Feature, Category

1, Feature1, Category1
1, Feature1, Category2
1, Feature1, Category3
2, Feature2, Category1
2, Feature2, Category2
etc

However, we now have a requirement to output this as a flat Excel file, so what we need to do is convert the above to the format :

FeatureID, Feature, Category1, Category2, Category3

1, Feature1, Category1, Category2, Category3
2, Feature2, Category1, Category2
etc

Hope that makes sense - couldn't figure out how to do it in Access, but wondered if it was more easily possible in Excel itself?

Cheers.