Table structure in load script

[ericdelaqua]

Hello help please!!!

I have the Table below and My expected output is also shown. I need help writing a query in the load script that will build the expected table for me.

thank you

Eric

[andrey_krylov]

Hi Eric. What is the logic of this table transformation?

[ericdelaqua]

Hi Krylov,

It is an important step to resolving another data quality issue. Data has just been captured badly. Any ideas on how this can be achieved?

[MK9885]

Can you attach a sample xl data for your example?