Rearrange data set

[Jack0091]

Hello I have the following data set

FROM_DATE	TO_DATE	FROM	TO	PRICE
2023-01-01	2023-01-31	1	160	.345
2023-01-01	2023-01-31	161	250	.234
2023-01-01	2023-01-31	251	400	.646
2023-01-01	2023-01-31	401	600	.423
2023-01-01	2023-01-31	601	9999	.874
2022-08-15	2022-12-31	1	160	.765
2022-08-15	2022-12-31	161	250	.324
2022-08-15	2022-12-31	251	400	.545
2022-08-15	2022-12-31	401	600	.762
2022-08-15	2022-12-31	601	9999	.927

I would like to rearrange it to look like this

FROM_DATE	TO_DATE	1	160	250	400	600
2023-01-01	2023-01-31	.345	.234	.646	.423	.874
2022-08-15	2022-12-31	.765	.324	.545	762	.927

[gawa · Accepted solution]

Hi @Jack0091 

Simply you can just use Cross Tab tool. Please refer to the attached workflow. If you have further query, please let me know.

[Jack0091]

Thank you it works !