jexcel - transpose question

Question

I am trying to work with JExcel API and had the following question.

I have queried my database tables for 3 columns: id, time, value. I am adding them into different arrays as objects. I want to output them into an excel sheet as follows:

 id      9:10   9:11   9:12

1       value  value  value

2       value  value  value

3       value  value  value

Where 1, 2 and 3 are the id's. The value is the value of that id at that time. I am not getting a clue how I could have all the input sorted as above as I need to do it for further analysis.

Any suggestions?