MSSQL 2K : Export Help Needed

[heather_j92002]

Is there a simple way to write the contents of table1 to a file as displayed below?

Table1

column1 column2 column3 column4

a b c d
1 2 3 4
xx gg cc ff

I need the data to be in a format like this:

a
b
c
d

1
2
3
4

xx
gg
cc
ff


I can only get dts to export / display the data the same way the column does and I have no idea on how to do write a file reformat program.
Please Help.

[MAK]

create table Table1(column1 varchar(10),column2 varchar(10),column3 varchar(10),column4 varchar(10))
insert into Table1 select 'a','b','c','d'
insert into Table1 select '1','2','3','4'
insert into Table1 select 'xx','gg','cc','ff'

select * from Table1

--results
column1 column2 column3 column4
---------- ---------- ---------- ----------
a b c d
1 2 3 4
xx gg cc ff

select column1+char(13)+char(10)+column2+char(13)+char(10 )+column3+char(13)+char(10)+column4+char(13)+char( 10)
as Column1 from Table1

--results
Column1
-------
a
b
c
d
1
2
3
4
xx
gg
cc
ff

[heather_j92002]

That is so helpful. Thank you!