how to show two column values in one row

[kavita25]

Hi,

sunindia‌

I want to show column1 values and 2nd column in one row..

For e.g

Id  Column1   Column2

1      125             -

1       300             -

1        -                  520

1        -                  452

Result:

Id  Column1   Column2

1      125              452

2       300             520

Please help me with this issue.

Regards,

Kavita

[kavita25]

Hi sunindia‌

Please see the excel files and qvw and help me to resolve this issue.

[PradeepReddy]

can you post the expected output, using the excel data which you attached..

[kavita25 · Accepted solution]

Thank You for all your support.

I solved it.

For reference PFA.

Regards,

Kavita