Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi Team,
Loved solving the challenge. I used the append tool to merge the data, followed by the text-to-column tool. I used a combination of select and filter tools to prep it and split it into two sets "Yes" and "No", to get counts for both I used the cross tab tool. And finally used the union tool to get them together and used the select tool at the end to format it one final time. Would love to know a better way to do it from everyone here.
Completed