How to select one row from multiple rowz and (repeated) Coulumns

[swatz]

i have a sample Table :

ID T_art Z_art F_ID

2101 s w 2
2101 a z 1
2101 s r 3
2102 s w 4
2102 a z 5


i want the result set like this:(Order By F_ID)

ID T_art Z_art T_art Z_art T_art Z_art

2101 a z s w s r
2102 s w a z

is there any way to achieve this in sql? it's urgent.any help is really appreciated.
Thank You.