Hello,
I need to show the contents of a table like a spreadsheet.
The table is structured like:
Color Size Order
001 S 10
001 M 5
001 L 6
002 S 8
002 M 9

The grid (or whatever) should reflect the contents like a spreadsheet:

Color S M L
001 10 5 6
002 8 9

The difficult part is, that the spreadsheet is editable (if the user changed the Number of orders, I want to change it in the table), and that the number of columns (and their names) vary according to the existing records. This means, if no size L exists for a selection, this column should not show up.
Any ideas??
I would be very happy, if someone could help me to find a solution.