SOLVED
Data Transformation
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
cmiles
7 - Meteor
‎06-08-2022
03:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have an Excel data file listing instructors and classes for various skills in a pivot table like format.
I need the data in a pre-pivot table format.
I tried Transpose, but the result is not what I need.
I have included a sample input data file and included an example of the desired output.
I’m sure the answer is somewhere in the Community, but I could not find the correct search term to locate the answer.
Any help would be greatly appreciated!
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Transformation
3 REPLIES 3
17 - Castor
‎06-08-2022
03:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @cmiles,
Here's a workflow which gets your desired output:
Any questions or issues please ask :)
HTH!
Ira
‎06-08-2022
04:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works perfectly!
Thank you for your very quick response.
17 - Castor
‎06-08-2022
04:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @cmiles ! Glad it worked for you 😄
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)