Data Arranging and formatting

[Feras95p]

Dear all,

I hope that you can help me in this a challenged part of the project that I want to make.

I have attached two excel files Input and Output. What I want is to make a workflow using Alteryx to input the input file that the attached one and the result of this input after designing the workflow the output should be the same of the attached file (Output file). So, any help in that please?

[fmvizcaino]

Hi @Feras95p ,

Would you be able to code color your files only to understand where some column names are coming from? For instance, the below columns.

Thank you,

Fernando Vizcaino

[Feras95p]

These columns are additional columns with empty cells just to be added without any data from input file.

[fmvizcaino · Accepted solution]

Hi @Feras95p ,

Since I thought you would need a automatic way of removing the title name separated by 2 rows, I have created a way of renaming your column names.

Take a look at the attached example and let me know if that works for you.

Best,

Fernando Vizcaino

[Feras95p]

Thank you very much, I really appreciate your efforts it works great !! but there is one more thing if you can help me in that, I want to have in the output file  in the order of columns  as the example file without the columns of the red highlighted one. Sorry I know I have asked a lot from you but it really means a lot for me  

[fmvizcaino]

Hi @Feras95p ,

Take a look at the example. If I understood you right, you can use the select tool to achieve what you are looking for.

Best,

Fernando Vizcaino

[Feras95p]

I DID IT !!!! Thanks a lot for your kind support you are the best. 

[fmvizcaino]

Thank you! I'm glad that I was helpful somehow @Feras95p !!!