Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

Erin
Cometa
Saqueador
I need more practice with transpose and crosstab. This was good.
arpit_tyagi
Meteoro

My take for this problem:

 

Algorithm which I followed :

 

1.Make a different group of textual and numerical data

2. Union text data

3.append textual and numerical data.

 

 

ARussell34
Asteroide

Here is my solution!

RamonaJ
Asteroide

Attached my solution

Racam1989
Meteoro

Fun use of cross tab and transpose here. Solved!

 

Saqueador
Racam1989_0-1622733319382.png

 

OliviTJ
Átomo

Here is mu solution

Petra999
Meteoroide
Saqueador
SpoilerAlteryx No.49.png
ShashankRaj12
Asteroide

  

Shelbey
Alteryx
Alteryx
Saqueador
Shelbey_0-1623261914173.png

 

apathetichell
Pollux

Didn't really have a strategy on this one but got there pretty quickly.