How to group all entry one one line

[david20100dispo]

I have that optional fields that gaves me headaches.

Field is called: OPTFIELD - and he contains around 12 entry ( that should be columns)

The value of the optional field is value

For example: 23027694 is on 4 lines instead of 1

thanks 

[ChrisWaspe]

Hi @david20100dispo . Your packaged workflow connects to a database. Please download a sample of data and package that. I suspect what you need to be using is a Cross Tab tool, grouping on the appropriate column.

[david20100dispo]

My Mistake here's the file

[ChrisWaspe]

I am not completely sure what your final goal is but a combination of pivots should get you started. You may need to do some further cleaning.

[binu_acs]

@david20100dispo one way of doing this

[david20100dispo]

Hi Chris,

When i try your way, All dates are on the same line of the item i purchase instead of a date / line

In the new attachment, 

Poporlo = the tables before i do my formula to split all optionnal fields in the optfield column

IETDD = the result when i do some transpose and cross tab manipulation

Thanks for the help

[david20100dispo]

Hi binuacs

When i try your way, i'm missing data, for example if i have 4 items on my PO, it only keeps 1 date, but every ither line of the po have different dates

In the new attachment, 

Poporlo = the tables before i do my formula to split all optionnal fields in the optfield column

IETDD = the result when i do some transpose and cross tab manipulation

The picture is to show i only have one date

[david20100dispo]

@ChrisWaspe and @binuacs  anyone have tried with the new files i provided?  thanks