Reorganize fields

**pollux** · 07-15-2010, 03:02 PM

Hello, I have a small problem. I have a table ordered this way:

Col0 Col1 Col2 Col3

Code:

head col0|head col1|head col2|head col3
1|1|a|
2|1||b
3|2|c|
4|2||d

After a query, I need to have the following

Code:

head col0|head col1|head col2|head col3
1|1|a|b|
2|2|c|d|

[...]

Basically, I need to group the values for Col2 and Col3 by Col1. I tried many things. Can someone give me a hint?
Thanks,
pollux

**TheShabz** · 07-15-2010, 03:04 PM