Turn Row Data into Vertical Dropdown

[zbaker]

I have data that is training classes and the columns list the class and cost and the when the classes are in the following columns. Is there a way to transpose this information so that a combobox will show the class dates vertically?

[June7]

Your data structure is not normalized. This will cause you lots of frustration.

Requires UNION query.

SELECT ClassName, datefield1 AS SomeName FROM tablename
UN ION SELECT ClassName, datefield2 FROM tablename
UN ION SELECT ClassName, datefield3 FROM tablename;