SOLVED
Guidance on Converting Rows to Multiple 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
CSEU
5 - Atom
05-17-2021
02:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx Community,
I have a question about transposing rows to columns, while maintaining one single row for all duplicate names. The data file I’m working with includes duplicate names, but the description fee and posted amount listed are different (see the gold highlighted columns). What I want to do is have only one row for each unique record, but with multiple columns that reflect the four-description fee amounts and the corresponding posted amount.
I have attached a sample of the data format. If someone can share some insight would be greatly appreciated.
Kind regards!
CSEU
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
2 REPLIES 2
dougperez
12 - Quasar
05-17-2021
02:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
05-17-2021
03:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @dougperez! This is exactly what I needed!