CrossTab help

[TSP]

Hi everyone.

I am struggling to convert the following

Input:

Field1	Field2
A	ABC
A	DEF
B	GHI
B	JKL
B	MNO
c_etc	etc

Desired Output:

A	B	c_etc
ABC	GHI	etc
DEF	JKL
	MNO

.

Any help would be hugely appreciated.

Many thanks,
TSP

[AngelosPachis · Accepted solution]

Hi there,

You need something to group on in your Cross Tab tool. I named the field as rows, but it can be anything you want 🙂

[grazitti_sapna · Accepted solution]

HI @TSP , another solution to your post.