Transpose data from one file to another

[trochovsky]

Good evening guys,

As the title says I pretend to transpose data from one file to another, but just specific bits so:



So I have this first excel in which I have several info that I want to transpose, namely:

Nº Doc, Fecha Doc., Cuenta, Referencia, Importe en Ml

The thing is that I only want specific rows to be transposed, let suppose for this exercise that are the ones who are colored gray, and I want them transposed to the following file:



In which the data must correspond to the specific colour,

Thanks in advance!