SOLVED
Split data in multiple tables
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
tanja90
7 - Meteor
‎12-02-2020
01:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have input like in example excel (sheet: "old") and I want to create output like in sheet "new". Values for column Years is not fixed, I'm expecting values for additional years. But I don't know how to do it, any help would be great.
Thank you for your time.
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
- Transformation
- Workflow
5 REPLIES 5
atcodedog05
22 - Nova
‎12-02-2020
01:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PhilipMannering
16 - Nebula
‎12-02-2020
01:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-02-2020
01:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎12-02-2020
01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @tanja90
Just a slight modification to @PhilipMannering to match headers as expected output
Output:
Hope this helps 🙂
‎12-02-2020
01:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator