HELP: Transposing Data Structure
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am struggling with getting an output that would transpose the values attached in the "Test Template2" in the table format as attached in "OUTPUT" excel files.
There are many unwanted columns and null rows/cells which has to be excluded to get the structure attached in "OUTPUT" excel file.
Any help on this would be super useful!.
Thanks,
db89
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @db89
Challenging data cleansing... Though it is not beautiful WF, it at least output the desired format. Please try this WF, and modify it so as to fit to your real data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think your workflow does great, the only thing its missing out is the '2023 Actual Paymt' column the final output. :)
But thank you for showing the way!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gawa thank you so much for your help with the complex request! :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @db89
Attached is the updated workflow, precisely tailored to your requirements. The output perfectly matches your specifications. Please mark as solved if satisfactory.
