Transpose Fields

[AGGGG]

Hi,

I am trying to transpose data in a table, so that it can be imported into another software package. Hence, I cannot change the format.

Hopefuly the data below will help explain my request. Any help would be appreciated.

Cheers, Andy

Current Data:
From To 0-10 11-20
AMS GLA 1 2
EDI LHR 3 4

Reuired Format:
From To
AMS GLA 0-10 1
AMS GLA 11-20 2
EDI LHR 0-10 3
EDI LHR 11-20 4

 

[alvechurchdata]

If the table is small enough and if this is a one-time job then you might do best to export it into Excel and work with it there.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[jrbarnett]

Something like:

select fromtext, totext, [0-10]
from yourtable
where [0-10] mod 2 = 1
union
select fromtext, totext, [11-20]
from yourtable
where [11-20] mod 2 = 0
order by fromtext, totext, 3

John

 

[r937]

SELECT [From]
     , [To]
     , '0-10' AS []
     , [0-10] AS []
  FROM daTable
UNION ALL
SELECT [From]
     , [To]
     , '11-20' 
     , [11-20]

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon