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.

I want to achieve below result:
Col A: Existing Data Column
Col B to Col K: Desired Add Column Result
(https://i.sstatic.net/DdHR2Y4E.png)

The data source could contain dynamically amount of unique keys (columns) to be added.

I tried the below steps:

1. Duplicated Col A
2. Transform > Split Column > Delimiter: newline & split at all occurrences

It did not work because it did it sort the key/value into the corresponding column & I do not want the “Key” to be included in the cell value.
(https://i.sstatic.net/Ddhrl0Q4.png)