Multiple rows combined by item number

[brad_j_crep]

I have a list of items where the ID is the same for multiple rows but not always the same number of rows.  There might be any number of columns following the id number.  What I want is one row for each ID number with all the rest of the data in separate columns.  So if field one for ID 1 has six rows there will be six fields showing what was in field one all on the same row.

Any help is appreciated.

Brad

[BenMoss]

I'm not entirely sure what you want your output data too look like.

Can you use the table tool in the reply to visualise what you are looking for.

I have a feeling you just need to check 'concatenate' as an option instead of first on the cross-tab but this may be because I don't understand what you are looking for.

Ben

[BenMoss · Accepted solution]

Okay I think I understand the problem a bit better now and have attached an amended version of your workflow.

I see you were trying to concat ID with the original header name, this didn't work because your name field was limited to 7 characters so you weren't seeing any change.

I've amended this to create a new field and then used this as the header field in the cross-tab instead.

I've also built out a logic to create an ID which restarts.

Ben

[brad_j_crep]

Thank you, you just saved hours of work time for an associate I was helping.  She will be thrilled!