Getting column values into row values (transpose)

[Mikael Lindqvist]

Hi,

For some odd reason does one of my table contain information that are of
same character in 5 seperate columns, they only containt "J" or "N" values.

I want to create a query that put all those column values in 1 column (and 5
rows).

Example: (PersonID, Column1, Column2,...,Column5)

Mikael, J, J, N, N, J

What I want is to change this table (with a query) so it looks like this:

PeronsID, NEWcolumn
Mikael, J
Mikael, J
Mikael, N
Mikael, N
Mikael J

But how?

Kindly,
Mikael
Sweden

 

[Mikael Lindqvist]

I forgot... union query will do it (sorry).

/Mikael