SOLVED
Transpose Issue
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jo-B
8 - Asteroid
‎11-07-2017
12:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear all,
I did today a lot of trail and error on the following issue.
I have a certain data set with many columns (Question Scores and Comments to each Questions).
ID | Q1 | Q1-Comments | Q2 | Q2 Comments | Q3 | ... |
1 | 10 | def | 9 | abc | 2 | |
2 | 9 | xyz | 10 | abc | 6 |
I am looking for the following layout to filter on on the different questions and comments.
ID | Question | Score | Comments |
1 | 1 | 10 | def |
1 | 2 | 9 | abc |
1 | 3 | ... | .. |
I know to transpose the column related to the scores of the questions, however how I can assign the right comment to the correct row?
I appreciate your help!
Cheers,
Johanna
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
jdunkerley79
ACE Emeritus
‎11-07-2017
12:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mrichards
6 - Meteoroid
‎11-07-2017
02:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-13-2017
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Both,
I could work with solution 2, although #1 is also quite Logical, however with my data i was a bit confused....
Thanks to you both!!
Best Regards,
Johanna