Ændre kolonner til rækker i ny tabel

SELECT Forhandlernr, Model1 FROM tabel
UNION
SELECT Forhandlernr, Model2 FROM tabel
UNION
SELECT Forhandlernr, Model3 FROM tabel
.
.
.

Oops, you obviously need Antal in each SELECT

Yes you are right - I need a table with 3 colums: Dealer, Model and Quantity

SELECT Forhandlernr, Model1, Quantity FROM tabel
UNION
SELECT Forhandlernr, Model2, Quantity FROM tabel
UNION
SELECT Forhandlernr, Model3, Quantity FROM tabel
.
.

does this help?

Sorry I haven't answered you before - I have been out of Office. No doen't help me I have the information about Model1 as a header and the quantity in rows.

I dont think I quite understand your problem!
You said that you have a table with the following columns

Forhandlernr
Model1
Model2
Model3
.
.

and looking at the data
Forhandlernr, Model1, Model2, Model3......
200            4        2      3
400            7        1      5

and you want to see the data like this
Forhandlernr, Model, Antal
200          Model1  4
200          Model2  2
200          Model3  3
400          Model1  7

well the SQL I gave will give you this, although the result may need sorting

otherwise you will need to explain!

Ah!
a little alteration

SELECT Forhandlernr, "Model1" as Model, Model1 as Antal FROM tabel
UNION
SELECT Forhandlernr, "Model2" as Model, Model2 as Antal FROM tabel
UNION
SELECT Forhandlernr, "Model3" as Model, Model3 as Antal FROM tabel

Yor last answer is working perfect !  Thanks for your help !

your welcome and merry christmas

it-fc, can you accept my answer so that we can close the question please?

thanks

thanks and once again a Merry Christmas