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?
