How to display multiple rows by monthame

[MHSmith]

Using sql server. Data returned:
smith, joe 1 10
smith, joe 2 5
smith, joe 3 6
smith, joe 4 1
zin, sally 1 7
zin, sally 3 9
zin, sally 4 6

How to display:

Name Jan Feb Mar Apr
Smith, joe 10 5 6 1
zin, sally 7 0 9 6

Can a gridview be used? Datalist?

[jhardman]

M,
Please clarify, are you using classic asp (vbscript, .asp file extension) or asp.net (usually written in c# or vb.net, .aspx file extension)?

Jared