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 · Accepted solution]

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

Then use a Cross Tab tool.

[k3pineapple]

Much Appreciated