Collapse the rows of a matrix of sparse data

[mattisch]

2005-07-05 144 x x x
2005-07-05 x 7060 x x
2005-07-05 x x 8010 x
2005-07-05 x x x 223
2005-07-12 146 x x x
2005-07-12 x 7050 x x
2005-07-12 x x 8000 x
2005-07-12 x x x 2123


How do i collapse this to
2005-07-05 144 7060 8010 223
2005-07-12 146 7050 8000 2123

[adamben]

How about a pivot table? It would need no programming at all - dates as Row Fields and four Data fields...