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'
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'