Merging columns data into rows

[Abcdefg090921]

Hi all, I have just transposed my data in to this orginal input. How do i merge the last 2 columns in the table into the rows from Name to Total amount? As the table and chair columns are the breakdown of the total amount. Attaching the file 'input' tab is the one i believe will be input into alteryx, while the 'output' tab is only for reference of the final output desired. 

Would appreciate all help thank you in advance!  

Original input: 

Name	Date of purchase	Receipt number	Item	Total amount	Table	Chair
Alex	01-Jan-24	6	Table & chair	25	10	15
Bryan	15-May-24	12	Table & chair	50	20	30
Catherine	26-Jun-24	34	Table & chair	75	30	45
Dini	14-Jun-24	65	Table & chair	25	10	15
Ethan	28-Mar-24	43	Table & chair	50	20	30
Frank	13-Apr-24	18	Table & chair	100	40	60

Expected output: 

Name	Date of purchase	Receipt number	Item	Total amount
Alex	01-Jan-24	6	Table & chair	25
Alex	01-Jan-24	6	Table	10
Alex	01-Jan-24	6	Chair	15
Bryan	15-May-24	12	Table & chair	50
Bryan	15-May-24	12	Table	20
Bryan	15-May-24	12	Chair	30
Catherine	26-Jun-24	34	Table & chair	75
Catherine	26-Jun-24	34	Table	30
Catherine	26-Jun-24	34	Chair	45
Dini	14-Jun-24	65	Table & chair	25
Dini	14-Jun-24	65	Table	10
Dini	14-Jun-24	65	Chair	15
Ethan	28-Mar-24	43	Table & chair	50
Ethan	28-Mar-24	43	Table	20
Ethan	28-Mar-24	43	Chair	30
Frank	13-Apr-24	18	Table & chair	100
Frank	13-Apr-24	18	Table	40
Frank	13-Apr-24	18	Chair	60

[flying008]

Hi, @Abcdefg090921 

FYI.

[Abcdefg090921]

Hi flying008, it seems like it is exactly what i was looking for! Do you have the workflow as reference for the formula? 

[flying008 · Accepted solution]

Hi, @Abcdefg090921 

The formula and tool's option all in the gif, please look again !