Is it possible to format a DataList using the <ItemTemplate> (or other) tag so that one column only displays a value when a new/different value occurs? An example would be something like the following, assuming all data is derived from one table, in a single query:
Any help is greatly appreciated.
Code:
ItemId_1 Option_1 Price_1
Option_2 Price_2 ' No change because ItemId is still "ItemId_1"
Option_3 Price_3
ItemId_2 Option_4 Price_4 ' Changes here
Option_5 Price_5
Any help is greatly appreciated.