Breaking a column into multiple columns (category, sub-category, etc.)

[QuestAlt]

Hi,

I have a financial data that has categories and sub categories in one single column - let's say Revenue as category, and multiple sub-categories for it. The total revenue represents the total of this sub-categories. Now, I would like to Have column 1 that has Revenue as its values for all the rows, and Column 2 that has those sub-categories as values.

Changing:

Revenue
Sales Product 1	1000
Sales Product 2	2000
Total Revenue	3000
Costs
Cost 1	-500
Cost 2	-900
Total Cost	-1400

To:

Revenue	Sales Product 1	1000
Revenue	Sales Product 2	2000
Revenue	Total Revenue	3000
Costs	Cost 1	-500
Costs	Cost 2	-900
Costs	Total Cost	-1400

Or even better, to:

Revenue		Sales Product 1	1000
Revenue		Sales Product 2	2000
Revenue	Total Revenue		3000
Costs		Cost 1	-500
Costs		Cost 2	-900
Costs	Total Cost		-1400

Any help to do this in Alteryx, or should I do it in Excel?

Many thanks,

Dan

[Ar13f · Accepted solution]

Dear @QuestAlt 

please find the workflow ... I hope this is what you want. I use multi-row formula to give remarks "Revenue" and "Cost" 

[QuestAlt]

Thank you - did the trick!