SOLVED
Tranforming Data - Rows to Columns
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
Kristie_Pires
8 - Asteroid
‎12-18-2022
03:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there,
How would you transform the data from the first table to the data on the second table? Whenever a loan has more than one guarantor, the guarantor name and ID should be displayed in another column.
Loan ID | Customer Name | Guarantor Name | Guarantor ID |
A | Mary | Peter | xxxx-11 |
B | James | May | xxxx-12 |
B | James | Lara | xxxx-13 |
C | Anna | Ryan | xxxx-14 |
C | Anna | John | xxxx-15 |
C | Anna | Chris | xxxx-16 |
Loan ID | Customer Name | Guarantor Name 1 | Guarantor Name 2 | Guarantor Name 3 | Guarantor ID 1 | Guarantor ID 2 | Guarantor ID 3 |
A | Mary | Peter | xxxx-11 | ||||
B | James | May | Lara | xxxx-12 | xxxx-13 | ||
C | Anna | Ryan | John | Chris | xxxx-14 | xxxx-15 | xxxx-16 |
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Preparation
- Transformation
5 REPLIES 5
TimN
13 - Pulsar
‎12-18-2022
03:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
TimN
13 - Pulsar
‎12-18-2022
03:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PanPP
Alteryx Alumni (Retired)
‎12-18-2022
03:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
‎12-18-2022
04:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-19-2022
11:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for helping me out! I always struggle with the Cross Tab and Transpose tool 😅
