I’ve got a text file that contains rows like this:
5633509 abstandardguids 1c2dc678-7053-11df-8ebf-be719dff4b22,1d470ac4-7053-11df-8ebf-be719dff4b22,1d2f3e58-7053-11df-8ebf-be719dff4b22
The third column is a series of GUIDs separated by commas, could be 1, could be 20 or more. I need to transofrm that into:
5633509 abstandardguids 1c2dc678-7053-11df-8ebf-be719dff4b22
5633509 abstandardguids 1d470ac4-7053-11df-8ebf-be719dff4b22
5633509 abstandardguids 1d2f3e58-7053-11df-8ebf-be719dff4b22
I was thinking the pivot would do this, but I’m not getting that output. Hoping there’s a trick I’m missing or maybe a different tool I should use?