Forum Discussion
pbiuser12345
Helper I
Helper ISplitting Multiple Delimited Columns Into Rows
Hello all, I have data that contains two columns with comma delimited data, that I need to transform from this: Project ID Name Technician Names Customer Names 10 Project Ten Alice...
try this
pbiuser12345Helper I
Helper IHi Rocco,
With my apologies on second look it's almost there but not quite. You will notice in the proposed solution (the 'asis' table), Tiffany has jumped from being a customer to a technician. The proposed transform works only as long as the count of technicians on a given row is >= the number of customers on the same row.
Any thoughts on how that could be addressed? I was wondering if it's possible to slip in dummy values as needed and then remove them after. Not sure if that could be done or not though.
Thank you again!
- pbiuser12345
Worked like a charm - thanks again!