Transpose & data preparation

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

Sampledata.xlsx

Preparation

Accepted answers

jrgo

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

Scheruku.yxmd

All comments

jrgo

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

Scheruku.yxmd

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

TRanspose and Prep.yxmd

Scheruku

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703