How do I rename columns using the first half of the column values?

Question

Hi, I have multiple columns that are written in Column_Title:### format and I would like to rename the column titles using everything before ":".

So far I've tried to use dynamic rename but I don't think that would work. I also could use text to columns with ":" as my delimiter but I don't want to create 22 text to column icons.

I think using RegEx might help me but I don't know how to use it. Can someone point me in the right direction?

dynamicrename.PNG

john_miller9 · Accepted Answer

You would want to first sample 1 row of data, then transform it so that it's a tall dataset, and then parse that field.  You can cross-tab that back as headers for your data