Challenge #224: Mushroom for Improvement

[TiwariVaishali]

My Solution

[shuman-p]

Methinks i got it, but surely there would be a more efficient approach than my (over)application of the "Find Replace" tool!

Regards,

[paulfound]

Didn't have mushroom in my calendar for this today!! Funguy right here! 

Spoiler

Some hefty RegEx - (?:\(|^ {4})((?=\S*['-])[a-zA-Z'-]+|\w+):\s(.*=(?:\w|\?))

[Spalders]

Spoiler

Had to prefix the Fieldname before the Join in order to get the right field order

- I see now that a Dynamic Replace provides a more elegant solution  

[StellaBon]

I got stuck on the Dang Crosstab again, but I learned how to use it in this situation from another poster who had taken a similar path as me. Better to do it with help than give up, I suppose!  

[Sudha8990AI]

Super Cool 🙂 

[RobertW]

Thanks

Spoiler

[RichoBsJ]

Hi! Here my solution 🙂

Spoiler

[kelly_gilbert]

I was thinking through how to keep the columns in the right order, and then I remembered a useful (but infrequently-used) tool!

Spoiler

[KaneG]

I didn't try to combine too many tools

Spoiler