Hi Hilaria,

It sounds like what you're needing isn't an ETL, but a PIVOT query to be done on the data.

Have you reviewed our PIVOT docs? It should give you the desired results you're seeking if I'm understanding you correctly.

https://www.labkey.org/home/Documentation/wiki-page.view?name=pivot

Regards,

Jon