If you are posting a question about how to transform a dataset, please include a short example of the input dataset(s) you have and the corresponding output dataset(s) you want. Often just a few rows is enough and you ca…