Split Strings Into Columns Based On Repeating Characters - Macro

[jessekanclerz]

I'd like to split information between the characters "=" and "&" into columns. "=" always appears first, "&" appears last. In each string there are multiple instances of "=" "&" that need to be in separate columns. The last instance of the string only contains "=" with no ending "&" and should be included in it's own column. Any help would be appreciated!

?utm_source=linkedin&utm_medium=display&utm_campaign=sfdc-sfdc-SkillsEU&utm_content=ad-text-WatchDemo-DemoSFDC1
?utm_source=google&utm_medium=cpc&trkid=V1ADW102982-7641943987-k-%2Bs+%2B-26396466787-b-s&gclid=CMLzvsz517kCFXMRtAod-i8AGw

[martindwilson]

is that 2 different lines?
i'd just find replace & with =
then split with text to columns delimited ,with = as delimiter