How do I flatten into one row records from Excel that are contained in two rows?
- 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, I have an Excel file where records look like this:
Store | Gross % Incr/Decr | Income | Expense | Net |
Jacksonville, FL | 26.3 | 32,000 | 16,000 | 16,000 |
32.5 | 64,000 | 30,000 | 34,000 | |
Moscow, ID | -18.5 | 24,000 | 43,000 | 34,000 |
2.5 | 34,000 | 65,000 | 45,000 |
(Those are made-up numbers.)
In the original Excel data source, the first line of data would be the Jacksonville store's current year info, and the second line would be the fiscal year-to-date info. Subsequently, the third line would be the Moscow store's CY, and the fourth year would be the Moscow store's FYTD info. I need Alteryx Designer to append every second row to the end of the row before it, so that each store's information is contained in a single line. I am not worried about column names; I'll take care of that in a SELECT tool afterwards. How can I do this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To clarify, this is what the desired outcome would be:
Store | Gross % Incr/Decr | Income | Expense | Net | Gross % Incr/Decr1 | Income1 | Expense1 | Net1 |
Jacksonville, FL | 26.3 | 32,000 | 16,000 | 16,000 | 32.5 | 64,000 | 30,000 | 34,000 |
Moscow, ID | -18.5 | 24,000 | 43,000 | 34,000 | 2.5 | 34,000 | 65,000 | 45,000 |
- 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
That worked perfectly. Thank you!
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)