Transpose & data preparation

[Scheruku]

Hello All,

We have data where we are trying to get the data in transpose format if a particular customer has same code consecutively for three or more months. Attached the sample data, and below the final output. Please help.

Name	Jan	feb	mar	april	may	June	July	Aug	Sep
Sai	88	88	88
vyan		46	46	46	46
vari							50	50	50

[jrgo · Accepted solution]

Hi @Scheruku,

I annotated each tool so I won't go into too much details here, but this should generate the output you're looking for.

Regards,

Jimmy

[jdunkerley79]

Took a slightly different approach to @jrgo

I used a lookup table to convert the month names to an integer (1-12). 

Then a couple of formula tool to create the next two months followed by a union to put together. I put the original set at the top so that they would dominate the generated data

I then added an adjusted month name back with a lead character to force the order on the CrossTab before putting into the format you wanted

Sample attached

[Scheruku]

Thank you so much for your time. 

[Scheruku]

This is a great solution. Thank you so much for your time.