Need help

[RE5260]

Hi All,

Need help here. Workflow attached.

I have 1 column, I wanted multiple column based on some certain value.

[AndrewDMerrill]

Here is a sample workflow that should do what you're looking for. Uses Multi-Row Formula Tool and Cross Tab Tool:

[RE5260]

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.

[AndrewDMerrill]

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)