I am not familiar in Power Query. I would like to achieve below result (split by delimiter, insert the values into the corresponding key column), which I managed to do so in VBA.
However, as my data source is really huge, I need this to be in a Data Connection, therefore I am exploring Power Query to achieve this result for me.