Power Query Editor - Unpivot Multiple Delimited Columns | Microsoft Community Hub (opens in new tab)
Hello-I'm looking for the most efficient way to unpivot multiple columns that have delimited data.For example, I have the following data:DateUserProductPositionJob1/1/20261234ABCPosition 1 | Position 2Job 1 | Job 21/1/20265678DEFPosition 3Job 3And I'm looking for the data to be as follows:DateUserProductPositionJob1/1/20261234ABCPosition 1Job 11/1/20261234ABCPosition 2Job 21/1/20265678DEFPosition 3Job 3
Read the original article