Hi All,
Need help here. Workflow attached.
I have 1 column, I wanted multiple column based on some certain value.
Here is a sample workflow that should do what you're looking for. Uses Multi-Row Formula Tool and Cross Tab Tool:
Hi AndrewDMerrill
It's not the output what I'm looking for. I have updated a text input tool stating Expected output.
There will be 5 data values on every products, rest numbers will not be needed.
That's an easy fix. You only need to add a Sample Tool, grouped by [Name] after the filter tool.
You could also just sample at the end of the workflow (after the sort). However you'd like to do it. (Included in workflow below)