Search

Close

Start 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

Good Exercise !! Learned more about the cross tab and transpose.

261 KB

Attached is my solution.

Here is my solution. 😉

My solution:

Number 20

Solution Attached

Sharing my solution, thanks for the challenge.

Hi,

Sharing my solution.

My first attempt to solve this I was going to use binary math:

I had columns set up, 1 for each of the 15 product types, and I was planning to just sum the values of the columns to get a string like : "001001001001001" to represent which products were bought.

Unfortunately I realised that binary math isn't a thing (!!!) and I realised there was an easier way to do this!

Much easier to use the built-ins Tools this way