Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
I added an extra input with the column headers and then joined on record id(finally found a good use case for that option!!) Really digging the make columns tool within Laboratory! It has become a very useful tool!
Here's my solutions -- one with Regex replace, one without. I took a look at other people's solutions and I like the use of Record ID for transposing/cross-tabbing! Wish I had thought of that!