Forum Discussion
Solved
Need help splitting column
Hey! I am having trouble breaking this CSV file out into distinct columns. The file is a csv directory consisting of lines indicating a ProductID, followed by a colon, and then customer ids and r...
In power query, add a column using 'if then else'
The logic is : if column2 is empty or null or whatever then column1 else null
Then do a 'fill Down' on the new column.
Then filter out the null/empty rows from Column2
---
Alternatively, search the text in Column1 to see if contains ':' to make a slightly different 'if then else'
You will need to go into Power Query and go to Transform > Pivot Column on the Items column. See this page for a better explanation of how pivoting works: https://support.microsoft.com/en-us/office/pivot-columns-power-query-abc9c8da-3be9-44c4-886e-0be331ab387a