Convert a Table , move information and rows

Danilo9017

Hi Guys 

I basically should modify the layout of my table. This is the visual of input 

You could see that report gives me a visual of invoices by client: 

In the first section we have : number of the client ("200320"), name ( "Luan SRL") Category (AGEN IT). 

then document date , amount and buckets  for each client. 

I need an output in different format : I need to copy and the paste  "category field" (AGEN IT , REST IT)  for each customer invoice  of the client. 

Is it possible to do it with Alteryx? 

Danilo 

input data test.xlsx

output data test.xlsx

Christine_Assaad

Thanks @Danilo9017  for confirming. Please see attached and below.

ConvertTable_Jul1922.yxmd