Arrange table 2 based on grouping of data in table 1

Summary

Arrange table 2 based on grouping of data in table 1

Content

Hi All,

I have below table on VBCS page coming from API.

Table 1:

ID	Name
12345	ABC
12345	XYZ
99999	RST
12345	ZZZ

I would like to group data like below on button click where i want to group based on ID and show both the table on screen.

Table 2:

ID	Name
12345	ABC
	XYZ
	ZZZ
99999	RST

Any pointer on this?

Best Regards,
Kalpesh Darji