convert rows to columns

[Parintas Themis STE Kardias]

Hi i have a table with data like this
f1 f2 f3
1 8 0
2 8 8
3 9 9
4 0 8
5 8 0
6 9 8
7 12 0
8 6 1
9 8 0
10 0 8

how can i convert the data from column to rows

1 2 3 4 5 6 7 8 9 10
8 8 9 0 8....
0 8 8 8 9..

[David Lloyd]

You can create a Crosstab query to accomplish this task. The following KB
article has more information.

http://support.microsoft.com/default...b;en-us;304349

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Parintas Themis STE Kardias" <st****@otenet.gr> wrote in message
news:di**********@usenet.otenet.gr...
Hi i have a table with data like this
f1 f2 f3
1 8 0
2 8 8
3 9 9
4 0 8
5 8 0
6 9 8
7 12 0
8 6 1
9 8 0
10 0 8

how can i convert the data from column to rows

1 2 3 4 5 6 7 8 9 10
8 8 9 0 8....
0 8 8 8 9..

[Alan Lane]

Hi:

Try this suggestion from Microsoft. Good luck!

http://support.microsoft.com/default...b;en-us;182822

Alan
"Parintas Themis STE Kardias" <st****@otenet.gr> wrote in message
news:di**********@usenet.otenet.gr...

Hi i have a table with data like this
f1 f2 f3
1 8 0
2 8 8
3 9 9
4 0 8
5 8 0
6 9 8
7 12 0
8 6 1
9 8 0
10 0 8

how can i convert the data from column to rows

1 2 3 4 5 6 7 8 9 10
8 8 9 0 8....
0 8 8 8 9..