Covert data in one table to 3 different table

[videet]

I have one big table want to convert it in 3 different table in one sheet only please see below input and expected output.

any thoughts on this?

Input Table

Payment Type	Account Receivable Details	Amount Payable (GBR)
Salary	101	100
Tax	101	100
National Insurance	101	100
Apprenticeship Levy	101	100
Rounding difference		100
Pen		100
Salary	101	100
]Tax	101	100
National Insurance	101	100
Apprenticeship Levy	101	100
Rounding difference		100
Pen		100
Salary	101	100
Tax	101	100
National Insurance	101	100
Rounding difference		100
Pen		100

Expected Output

	Reporting Location:abc
	Payment Type	Account Receivable Details	Amount Payable (GBR)
	Salary	101	£100.00
	UK Tax	101	£100.00
	National Insurance	101	£100.00
	Apprenticeship Levy	101	£100.00
	Rounding difference		£100.00
	Pen		£100.00
	Reporting Location: abc
	Payment Type	Account Receivable Details	Amount Payable (GBR)
	Salary	101	£100.00
	UK Tax	101	£100.00
	National Insurance	101	£100.00
	Apprenticeship Levy	101	£100.00
	Rounding difference		£100.00
	Pen		£100.00
	Reporting Location: abc
	Payment Type	Account Receivable Details	Amount Payable (GBR)
	Salary	101	£100.00
	UK Tax	101	£100.00
	National Insurance	101	£100.00
	Rounding difference		£100.00
	Pen		£100.00

[ChrisTX]

In your input data there are 3 rows with data   Salary    101    100

Will those 3 rows always be the same?  If they are not the same do you want the workflow to generate an error or just use the first occurrence and ignore the others?

Try this:  Use a Unique tool on all 3 fields, then a Formula tool to correctly format Amount Payable as a string and include the Pound symbol and decimal.

I'm guessing the data type for the Amount Payable field is numeric?  You will need to create a new field to change the data type using a Formula tool. Then you can use a Select tool to drop the original field and re-name the new field.

Use a formula like  "£" + ToString([Amount Payable], 2)

Here is a list of all functions:  https://help.alteryx.com/current/designer/functions

Chris

[videet]

@ChrisTX 

I have generated all the data i just want to configure input data as shown earlier like below screenshot

As in input data you can see all the data is under one header i want to spilt it in 3 different table as below