Help with arranging a dataset

[bb]

Hello everyone,

If I have a dataset that looks like this:

Record #              Value

1                         Request Disposition

1                         Date of claim contains line break.

2                         Manual Review Required.

2                         Request Disposition

3                         Error on authentication

3                         Manual Review Required.

3                        Contains trailing space.

and I want it to look like this:

1	Request Disposition	Date of claim contains line break.
2	Manual Review Required.	Request Disposition
3	Error on authentication	Manual Review Required	Contains trailing space

How do I do this? I tried using crosstab and everything but it does not work. Also, please note that the value column is a string.

Any help on this would be awesome.

Thanks in advance.

[Thableaus · Accepted solution]

Hi @bb 

Here's a solution:

- Transpose your data grouping by Record

- Use Tile Tool to create a sequence that will define your new fields

- Use Cross-Tab Tool to put in your layout

WF attached.

Cheers,