Forum Discussion
Split column based on a regular expression pattern
I have a column where each row follows this format: Requested For = Joe Service = Coffee Class = Espresso Type of Request = Replace Coffee Machine Describe the Request = Coffee Machine needs ...
Hi makarama ,
Here are the steps you can follow：
1. In power query – Transform – Split column – Custom -- =.
Result:
2. Select [Column.1] – Transform – Pivot Column – [Column2] — Don’t Aggregate.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for your time but the input data you used in your example is not what I have. This part:
Requested For = Joe
Service = Coffee
Class = Espresso
Type of Request = Replace Coffee Machine
Describe the Request = Coffee Machine needs to be replaced
Request Number = 1213123
Further Comments =
is a single string. A single data point in the matrix. It does not span across multiple rows.