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 

[Danilo9017]

Hi @christine_assaad 

I marked as a solution 

It works perfectly. It is wonderful!! many many thanks for your help and your patience. 

Danilo