SOLVED
Unmerge cells, copy values and transpose multi rows
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
Kevincoco
6 - Meteoroid
‎02-04-2021
07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi the Alteryx community,
I would need some help to figure out a workflow that transform the data that I have in tab "sheet 1" into format of the tab "sheet 2".
I already spent some time with transpose and multi rows formula without any success 😞
Any idea? I attach the excel file and screenshots of the tabs.
Thanks in advance 🙂
Kevin
sheet 1
sheet 2
Solved! Go to Solution.
Labels:
4 REPLIES 4
JulioMO
9 - Comet
‎02-04-2021
08:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-05-2021
12:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks JulioMO 🙂
Exactly what I wanted!
Now how would you (using the workflow) bring back the data to the old structure?
Background:
Here i want to update the product information in Alteryx and then bring back this info to the excel file
JulioMO
9 - Comet
‎02-05-2021
01:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-05-2021
03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks JulioMO 🙂
