Challenge #49: Reformatting Transactional Data

[ntakeda]

My solution.

[jay_char]

Good for practicing!

[mrararaman]

Salient points as per the approach taken here:

• Keeping the column F1 common, select, pair & treat one value column at a time (amongst F2, F3, F4 & F5)
• Creation of a macro (attached NewMacro1.yxmc) to treat one pair of columns at a time.
• Usage of Union tool for stacking up the results

Thanks,

Ananth

[mithily]

less elegant than the solution but it got the job done

[Rob_1]

My solution

[CBarito]

🙂

[CVCurcurato]

Great refresher on transpose and crosstab after not using it for a while!

 

[JS1989]

Great challenge

[josedlr00]

Good challenge, good practice for crosstab and Transpose tool

[Sebastian_Chaieb2]

My solution

Spoiler