Simple transpose

[Andrzej]

I have a simple table with spatial objects (Polygons).

Point number	Spatial Object
1	a
2	b
3	c
4	d
5	e
6	f
7	g

I would like to transpose rows to columns (sth like excel transpose).

1,2,3... should be names of columns, and a,b,c... values of columns

1	2	3	4	5	6	7
a	b	c	d	e	f	g

What is the simplest way, to achieve it?

Greetings

Andrzej

[Thableaus]

Hi @Andrzej 

You need to use the Cross-Tab tool.

It's under the Transform tab.

Use Your first field as Headers and the 2nd fields as values for these Headers.

Cheers,

[Andrzej]

Dear @Thableaus

I do not have an option to concatenate. Maybe it is because I really used a spatial object. 

Cheers

[Thableaus · Accepted solution]

@Andrzej 

You can use the First or Last option.

It doesn't really matter.

Cheers,

[Andrzej]

Thank you,

previously I was using group by option and it didn't work properly. 

Now everything is ok

Regards

Andrzej Gabryel