Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
First split up the data into rows using text to column to rows based on whitespace then used regex to identify the hashtags and then some data manipulation to get the data in the appropriate format.