SOLVED
Merging columns data into 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
Abcdefg090921
5 - Atom
‎11-06-2024
06:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all, I have just transposed my data in to this orginal input. How do i merge the last 2 columns in the table into the rows from Name to Total amount? As the table and chair columns are the breakdown of the total amount. Attaching the file 'input' tab is the one i believe will be input into alteryx, while the 'output' tab is only for reference of the final output desired.
Would appreciate all help thank you in advance!
Original input:
Name | Date of purchase | Receipt number | Item | Total amount | Table | Chair |
Alex | 01-Jan-24 | 6 | Table & chair | 25 | 10 | 15 |
Bryan | 15-May-24 | 12 | Table & chair | 50 | 20 | 30 |
Catherine | 26-Jun-24 | 34 | Table & chair | 75 | 30 | 45 |
Dini | 14-Jun-24 | 65 | Table & chair | 25 | 10 | 15 |
Ethan | 28-Mar-24 | 43 | Table & chair | 50 | 20 | 30 |
Frank | 13-Apr-24 | 18 | Table & chair | 100 | 40 | 60 |
Expected output:
Name | Date of purchase | Receipt number | Item | Total amount |
Alex | 01-Jan-24 | 6 | Table & chair | 25 |
Alex | 01-Jan-24 | 6 | Table | 10 |
Alex | 01-Jan-24 | 6 | Chair | 15 |
Bryan | 15-May-24 | 12 | Table & chair | 50 |
Bryan | 15-May-24 | 12 | Table | 20 |
Bryan | 15-May-24 | 12 | Chair | 30 |
Catherine | 26-Jun-24 | 34 | Table & chair | 75 |
Catherine | 26-Jun-24 | 34 | Table | 30 |
Catherine | 26-Jun-24 | 34 | Chair | 45 |
Dini | 14-Jun-24 | 65 | Table & chair | 25 |
Dini | 14-Jun-24 | 65 | Table | 10 |
Dini | 14-Jun-24 | 65 | Chair | 15 |
Ethan | 28-Mar-24 | 43 | Table & chair | 50 |
Ethan | 28-Mar-24 | 43 | Table | 20 |
Ethan | 28-Mar-24 | 43 | Chair | 30 |
Frank | 13-Apr-24 | 18 | Table & chair | 100 |
Frank | 13-Apr-24 | 18 | Table | 40 |
Frank | 13-Apr-24 | 18 | Chair | 60 |
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
3 REPLIES 3
flying008
15 - Aurora
‎11-06-2024
07:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-06-2024
11:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi flying008, it seems like it is exactly what i was looking for! Do you have the workflow as reference for the formula?
flying008
15 - Aurora
‎11-07-2024
12:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
