I have read Jeff Moden's series on converting rows to columns but can't see how to do what I need to do. The scenario is this:
I have two fields - Model & Feature, which represents cars (models) that have features (i.e. 3 doors, air-conditioning etc.), and the data is transactional, so if a Model hs more than one feature there is more than one row.
The question is - how do I get the Features into columns, and here's the rub - the number of features is not fixed, and they are all different. SO what I'd like is:
Model A | Feature 1 | Feature 2
Model B | Feature 1 | Feature 2 | Feature 3
and Feature 1 on Model A is not necessarily the same as Feature 1 on Model B.
Is this do-able? All assistance *gratefully* received.