Challenge #49: Reformatting Transactional Data

[YadTheTabLad]

[beatriz_alteryx06]

Weekly Challenge solved.

[Dibas98]

Solution

[ABhattacharya]

Sharing my solution for Weekly Challenge #49.

[Felipe_Ribeir0]

Here is my solution.

[Felipe_Ribeir0]

Here is my solution (but like some previous folks, i also think that this survey data having two difference responses concatenated on the same column is a little strange)

F38

Age

8-Prefer not to answer

5-45-54

[Bobbyt23]

Spoiler

Transpose Crosstab, crosstab transpose 😁 I also enjoy being able to do multiple things within the join tool, really powerful.

[Rhys_Cooper]

Quite a tricky challenge - good example of how the column names can be used within the join condition after the transformations.

Spoiler

[OlonJohnson]

Similar to other solutions. Concat + Text To Columns is a great tool combination for this issue