Transpose column data to single row

k3pineapple

Hi Team, would like to achieve the output below.

Many thx

City	Unit	Code	group
ABC	99	AAA	Aaaaa
ABC	99	AAA	Aa
ABC	99	BBB	Bbbbb
ABC	99	BBB	Bb
ABC	99	BBB	Bbb
ABC	99	BBB	BbbbB

City	Unit	Code	group1	group2	group3	group4
ABC	99	AAA	Aaaaa	Aa
ABC	99	BBB	Bbbbb	Bb	Bbb	BbbbB

Qiu

@k3pineapple 
We can either use a Tile or Multi-Row Formula tool to create the Group Sequence number.

Then use a Cross Tab tool.

0826-k3pineapple.yxmd