Fill in blanks and concatenate multiple headers

[leoc06]

Hey Community 🙂

I only have a couple hours of experience in Alteryx and I'm getting lost with transposes, cross tables, IDs and multi row formula. I'm trying to deal with this table with 3 lines of headers. My initial idea is to transpose the three, fill in the blanks with multi row formula and concatenate the three. Any thoughts?

Regards,

Company	Code	City	Date	Revenues				Costs
				Revenues from services			Financing revenues	Direct costs		Indirect costs
				Revenues from Credit operation	Revenues from Exchange	Revenues from Other services		Acquiring costs	Loans operation costs
A	456219	Sao Paulo	Feb-13	32106,75317	71873,85051	91039,27962	60903,61826	54570,29284	31620,32358	41520,12685
A	456219	Sao Paulo	Feb-14	74062,2275	26339,90107	9993,366154	33936,46665	41964,06257	48192,86078	68683,18976
A	456219	Sao Paulo	Feb-15	41331,54202	13007,71572	53424,13794	34909,17067	54586,70948	93065,40218	92512,82569
B	498753	NY	Feb-13	99085,06158	17131,59912	58250,17724	10023,42733	59301,62895	5334,222868	20529,39147
B	498753	NY	Feb-14	78189,61256	38782,21719	19754,99145	40815,00924	6217,711413	82786,26717	92621,30044
B	498753	NY	Feb-15	86009,20787	56890,26742	2223,638076	24048,50866	32357,63393	10801,89068	91271,41006
C	502167	Shanghai	Feb-13	42400,33797	16356,48137	25864,68441	53732,30338	36061,10173	60807,03713	21572,0572
C	502167	Shanghai	Feb-14	62406,07124	85704,04324	76392,09989	8278,761537	56948,78271	46459,81045	8550,172222
C	502167	Shanghai	Feb-15	90421,63556	32270,23519	57409,24819	29186,47876	79670,03003	92645,56538	85307,40797

[atcodedog05 · Accepted solution]

Hi @leoc06 

Here is how you can do it.

Step 1: Make sure to configure input tool to get data from first row by configuring as highlighted below

Step 2: Try this workflow

Hope this helps : )

[atcodedog05]

Happy to help : ) @leoc06 

Cheers and have a nice day!

[leoc06]

Thanks a lot atcodedog05! Never occurred to me using Summarize!