Forum Discussion

steven_osman's avatar
steven_osman
Regular Visitor
8 years ago
Solved

show multiple columns as rows with dynamic columns based on values

Hello,    I have a table of values as shown below :     A B C D E xx 1 0.5 0.3 0.2 xx 2 0.6 0.1 0.3 yy 1 0.8 0.2 0 yy 2 0.4 0.4 0.2 yy 3 0.2 0.2 0.6 ...
  • erikajain02's avatar
    erikajain02
    8 years ago

    Hi,

     

    You need to unpivot you table first. Look at the snapshot for the steps.

    I have attached sample for you to achive the required result.

erikajain02's avatar
erikajain02
Icon for Resolver I rankResolver I
8 years ago

Hi,

 

You need to unpivot you table first. Look at the snapshot for the steps.

I have attached sample for you to achive the required result.