I'm facing another strange issue from my users, who love Excel sheets. Can I transform / mix / change rows and columns in one list using only a views? Is it possible to make this view (or list):
... from this original one?
The original list has one row per day and three choice columns called System 1, 2 and 3. New view (or more likely new list) must have systems in one column, three rows per one day with values from choice columns as "Contact".
Changing view styles will not help me, neither lookup column, because values are choices.
If it is really possible without Excel sheet to be attached, what is the best way to do it? Thank you for any clue.