Horizontal Ordering

[Guest]

I'm dealing with some flat data which looks like the following:

Field1 Field2 Field3
CD B1 B2
B2 B1 CD
CD B2 B1
B1 CD B2

For my purposes, all four records have the identical meaning. I would like
to put them in order left-to-right so I can remove what I consider to be
duplicate entries.

 

[Allen Browne]

Any chance of turning this into a normalized structure with a UNION query?

Example:

SELECT Field1 AS Product FROM Table1
UNION ALL
SELECT Field2 AS Product FROM Table1
UNION ALL
SELECT Field3 AS Product FROM Table1;