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 |
Solved! Go to 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.
Thank you it works !