Transpose the data

[girish_talele]

Dear Experts,

We have data as given in Data Table below. We want to transpose the data as given in Result Table.

One way to achieve this result is through Pivot Chart, but we want to store the data in qvd in this manner only.

Please suggest how to map the requirement.

Regards,

Girish.

[ashfaq_haseeb]

Hi,

Check if this helps

you need macro for the same.

Regards

ASHFAQ

[sujeetsingh]

Follow generic load .

What is Generic load and when we used Generic load.

[lironbaram · Accepted solution]

hi have a look

at the attach example

it uses generic load

[girish_talele]

Dear Liron,

Thank you very much. It resolved our query.

Regards,

Girish.