CrossTab/Transpose - Rearrange data

timewaste

Hello all,

I have data that looks like this:

F1	F2	F3	F4
1	A	FF1	A
1	B	FF2	AB
1	C	FF3	ABC
2	A	FF1	D
2	B	FF2	DE
2	C	FF3	DEF

Now my goal is to output the data like this:

F1	F2	FF1	FF2	FF3
1	A	A
1	B		AB
1	C			ABC
2	A	D
2	B		DE
2	C			DEF

But when I use a Cross tab tool with Concatenation set , the output I get is:

F1	F2	FF1	FF2	FF3
1	A	A,,	,AB,	,,ABC
1	B	D,,	,DE,	,,DEF

 How do I accomplish this? Please advise.

Thableaus

No problem @timewaste 

I think maybe what you need to define here is the sequence of your fields' arrangement.

So, I'd use the Tile Tool for that:

Then, the Cross-Tab Tool grouping by this sequence as well:

See if it works well now.

Cheers,