Combine multiple columns?
- 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 Everyone,
I'm hoping I can combine multiple columns or rows that have the same data in the first record. I tried to use dynamic renaming to make the first record my header then summarize but it wouldn't allow duplicate naming. I just want one column of all machines one of all Grade type and one of all scale. Thank you for any advice!
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kceesay Alteryx will not allow the same name for multiple columns, the column names should be unique. What is the expected output here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I just want one column of all machines, one of all Grade type and one of all scales.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kceesay would you be able to upload the input data in excel?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, I've attached the file. What I currently have is in sheet 1 and I'm looking to have what's in sheet 2.
- 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
This worked Thank you!!
