convert the haphazard excel data into consumable format

[SubbuSharma]

Hello, 

I have a peculiar situation where the haphazard excel data needs to be converted into consumable format. 

Attached excel file has two tabs 1) Raw Data 2) Desired Results. 

Kindly let me know if this is doable. Candidly speaking, I have run out of ideas and need help in getting this fixed.

thanks

Subbu

[MeganDibble]

Hi @SubbuSharma,

From looking at the dummy data, I am curious if your data started out as a .csv file? If so, it should remain in a .csv file and then you should use the pipe delimiter ("|") when importing the .csv in Alteryx. 

If the data was never in .csv format, you can try the solution attached :) 

[SubbuSharma]

Thanks Megan for the workflow. However, I was looking for an output something in the "desired results" tab.

[grazitti_sapna]

Hi @SubbuSharma , I have created the workflow as per your desired output. Please check and accept my solution if it fulfills your requirement.

Thanks!!