How do i insert couple of rows heading above my column names

[videet]

I have input file like below just want to insert some rows with data above col names as shown in output with same configuration.

Any help will be appreciated.Thanks.

Input

EmpId	Name	JobTitle	Years od Service	County	Location	Email	Ph no	Account	Project Code	Interco Segment	Future Value
1	a	p	5	Ind	xyz	abc	123	100	1	0000	0
2	b	q	6	Ind	xyz	def	234	101	1	0001	0
3	c	r	7	Ind	xyz	pqr	456	102	1	0002	0
4	d	s	8	Ind	xyz	qwe	567	103	1	0003	0

Output Expected

	Client Name
	Emp Detailed Report
						Alteryx Report
EmpId	Name	JobTitle	Years od Service	County	Location	Email	Ph no	Account	Project Code	Interco Segment	Future Value
1	a	p	5	Ind	xyz	abc	123	100	1	0000	0
2	b	q	6	Ind	xyz	def	234	101	1	0001	0
3	c	r	7	Ind	xyz	pqr	456	102	1	0002	0
4	d	s	8	Ind	xyz	qwe	567	103	1	0003	0

[Qiu]

@videet 
If you dont have problem with Reporting Text tool, we can do something like this.

[hellyars]

@videet The question is do you need those values to be in specific cells relative to the field names in the base data table?  If not, @Qiu's solution works.  If yes, there is another way to do it using some of the reporting tools.  

[mceleavey]

Hi @videet ,

In addition to the suggestions made by @Qiu and @hellyars you can also simply add text rows, use the Union tool with record positioning and specific order selected:

I've attached the workflow.

M.

[videet]

@mceleavey 

Everting is perfect in you workflow just 1 thing i want Alteryx report heading to range from Column G to M(as single col) as shown in below screenshot and in bold font

Any suggestion.

[apathetichell]

Hi,

If you want to merge cells you're going to back to a report based solution - here's some modifications to @Qiu 's work... If you want to make the merged cells larger or smaller that's table 1- your data is table 2. You can edit/reformat the text in the report text section.

Note - I didn't even know that there was a summarize/report section until an hour ago and was like "huh... when am I going to you that..."

[videet]

@apathetichell 

Alteryx report heading should be from email col to future value col not entire row rest is perfect

can we do that?

[apathetichell · Accepted solution]

Here's a slight modification which adds a second (fake) column to the header table and then plays around with the formatting.

Original upload had the wrong file - here's the correct one.