Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

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.

share|improve this answer
    
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 '12 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 '12 at 20:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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