grouping into different columns

[jcastr02]

I am trying to seperate a column work order tag reason when the WO order number is the same, see example, it would break it out into different columns.  The last 4 rows are the same work order number, so those would have the Tag Reasons seperated into seperate columns.  all other fields would stay the same.  

[v-janeyg-msft]

Hi, @jcastr02 

According to your description, the requirement is inconsistent with the PQ function calculation logic. For example, the order number you provided has four rows that require four custom columns. If other order numbers have many rows that are not repeated, how many additional custom columns should be added? If you do this is to realize an idea in the report, you can put it forward and let me see if i can help you.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcastr02]

@lbendlin See below  and appreciate your help.  Essentially what I am trying to do is sort of pivot the Work order tag reason column / split it when the work order number matches.  

[lbendlin]

Please provide sample data in usable format (not as a picture) , show the expected outcome, and give sufficient context.