Challenge #155: March Cryptanalytics

[Inactive User]

Enjoyed this one!

[Greg_Murray]

This was a fun one! 

Spoiler

[AbiramiJothi]

Interesting one,Thanks @TerryT

I used the Concatenate Macro by Joe_Mako as a last step. Thanks @Joe_Mako!

Spoiler

[kat]

Thanks, @danilang ! :)

[mst3k]

Spoiler

SPOILER

Hi,

This is my first weekly challenge attempt. I liked it. Highlight below for my answer:

knock Knock Who's there? Irish! Irish Who? Irish you a happy St. Patrick's Day!

My approach used 8 tools including the Input/Output.

Input -> RegEx -> Transpose -> Summarize -> Formula -> Sort -> Summarize -> Browse

[mst3k]

sorry my browser posted my reply twice.. not sure how to delete this one just edit it.

[nerces]

Spoiler

Had to think this one through a bit before starting to work on it. Finally came up with the idea to split the data into single characters and use the frequency tool to get the frequency of each character in each position. I then summarised to get the max frequency for each position and joined back to the frequency tool to pull through the actual character value. I then sorted by position number and summarised again to turn the multirow data into one field with the full decrypted message.

First challenge I've ever attempted, thank you!

[mtouiti]

Happy St. Patrick's Day! to all the Irish folks

Spoiler