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):

enter image description here ... from this original one?

enter image description here

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.

1 Answer 1


This doesn't really solve your problem directly but the usual way I see this addressed is to simply group the view based on the column in question, "System" in your case. The presentation is a bit different but usually works for most people.

  • This can work in first case, but it will be result. The original list has separate column for each system and it cannot be grouped (no more than two cases).
    – Molik
    Feb 15, 2012 at 19:32
  • In that case, a Calculated field for System based on System1, System2, System3 might be what you are looking for. Here is a rather extreme example : kartickapur.wordpress.com/2007/11/12/…
    – Dave Wise
    Feb 15, 2012 at 20:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.