Complex Data Massaging

[SH_94]

Dear Community,

I would like to massage the data in order to derive the result as per screenshot below . The original sample data i have included in the excel below and it seem to be complex .

Would like to seek assistance if someone know how to build the solution to massage the complex data.

Many thanks for your help.

[atcodedog05 · Accepted solution]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Thanks a lot for your prompt response.

Maybe i think too much on how to massage the data and after seeing your workflow, i just notice that we can build the workflow in this way.

It is really amazing and interesting.

Thanks again for the help

[atcodedog05]

Happy to help : ) @SH_94 

Cheers and have a nice day!

[SH_94]

Hi @atcodedog05 ,

I have another query on the massaging the data. May i know how can i add one column so the output will be as per screensot below:

The original data is located as per screenshot below.May i know if alteryx can change the format automatically to word ? As my reports have 12 month (different reports) and would need to convert for all the date.

Many thanks again for the help

[atcodedog05]

Hi @SH_94 

You would need to do something like this.

Workflow:

Hope this helps : )