Forum Discussion

PeterJansen2's avatar
PeterJansen2
Frequent Visitor
9 years ago
Solved

Pivot problem and mixed data

Hi,   I have a brainbuster (for me)   I have a table which I want to Pivot. All content is Text. I would like to Pivot the table to get the following result: This presents me with t...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi PeterJansen2,

     

    3) Converting Text to Numeric works only for the 1000 and 2000 code, which is all I need, but the other codes will present an error.

    If the other codes is not needed/necessary, you can replace the error values with null or 0(or any other values you want to show) after Converting Text to Numeric. Then you should be able use the Pivot option get your expected result. :smileyhappy:

     

     

    Final result:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi PeterJansen2,

 

3) Converting Text to Numeric works only for the 1000 and 2000 code, which is all I need, but the other codes will present an error.

If the other codes is not needed/necessary, you can replace the error values with null or 0(or any other values you want to show) after Converting Text to Numeric. Then you should be able use the Pivot option get your expected result. :smileyhappy:

 

 

Final result:

 

Regards