Transpose Crosstab

Hi All,

I have a raw data set, very unorganized file and I am aiming to create a flat file out of it for modeling purpose. However, I tried creating the workflow using Transform and Crosstab macros and I am stuck. It would be great if I can get some help from the experts.

I have attached the example for the input and the output.

Thanks in anticipation.

Regards

Data Financial Input (1).xlsx

Data Financial Output - 2.xlsx

Transformation

Preparation

Accepted answers

geraldo

@gmamtani

Here's an example workflow

CrossTabExcel.yxmd

geraldo

@gmamtani

sorry, when I put the select tool I didn't correct the columns. Check as it is in the print.

geraldo

@gmamtani

New Workflow

CrossTabExcel.yxmd

All comments

geraldo

@gmamtani

Here's an example workflow

CrossTabExcel.yxmd

gmamtani

Hi Geraldo,

Thanks a lot for sharing the solutions. I am not able to see the values in the output. I have attached the screenshot of the output.

Many thanks.

Regards

Capture.PNG

geraldo

@gmamtani

sorry, when I put the select tool I didn't correct the columns. Check as it is in the print.

gmamtani

Great!!

Thanks Geraldo for sharing the solution.

You made my work really easy, I was stuck with this for a couple of days.

Thanks again

gmamtani

@geraldo

Just one question.

When I loaded the real raw data in this workflow, I could only see the data for the fist company. The data for the other companies is not reflecting. What should I do ?