Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

abhishekahuja35
7 - Meteor
Spoiler
abhishekahuja35_0-1686342073244.png

 

Interesting, learned about doing transpose as in Excel

The_Rad_Valentina
8 - Asteroid
8 - Asteroid
Spoiler
The_Rad_Valentina_0-1686777480381.png

 

StephanieYou
8 - Asteroid
Spoiler
StephanieYou_0-1686801187689.png

 

jamesbodolay
7 - Meteor

fun one

hlee36
8 - Asteroid

Attached is my workflow and macro file I created. 

Lenusa
8 - Asteroid
Spoiler
Lenusa_0-1687179274338.png

 

bmerril6
7 - Meteor
Spoiler
bmerril6_0-1687182755034.png

Split into header rows and data rows, transpose both to right format, join using original column names, split product/market/type data into 3 columns, rearrange column order/type/name.

aroumpelaki
8 - Asteroid

The crosstab/transpose combination still gets me :)

IanHealey
8 - Asteroid

Solution

ejhaley
8 - Asteroid
8 - Asteroid
Spoiler
Capture.JPG