How do I flatten into one row records from Excel that are contained in two rows?

[SergeantJack]

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?

[SergeantJack]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @SergeantJack 

Try the attached workflow

[SergeantJack]

That worked perfectly.  Thank you!