SOLVED
Data Preparation
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
ayadav8
8 - Asteroid
‎05-22-2018
01:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am looking to transform my input file so that I can do some analysis on it. The file consists of only 3 columns but these are distributed across spreadsheet columns. I need to group them together in only 3 columns.
I have attached the spreadsheet example to better explain my case. Hope I am clear.
Thank you so much.
Solved! Go to Solution.
Labels:
3 REPLIES 3
17 - Castor
‎05-22-2018
03:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you have input this data into Alteryx, you may have noticed that duplicate column names will have a number appended to the end of each occurrence. Relying on this, I created the attached solution.
ponraj
13 - Pulsar
‎05-22-2018
10:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-23-2018
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)