Creating a single record from multiple records with a unique key

[Marc via AccessMonster.com]

I am trying to change a vertical list of records with a unique key to a
single horizontal record. See this example:

Current Query output
KEY Index Type Data
123456 1 ELA
123456 2 G
123456 3 15
123456 4 756

Desired Output
KEY 1 2 3 4
123456 ELA G 15 756


Can somebody help?

Marc

 

[Guest]

Use a CrossTab query --
TRANSFORM First(Table4.DATA) AS FirstOfDATA
SELECT Table4.KEY
FROM Table4
GROUP BY Table4.KEY
PIVOT Table4.TYPE;