Forum Discussion
Solved
Splitting Column into Rows Blank Value Affects Realtionship
am hoping someone can help, i have split a Column into Rows and the values (text) are showing up as blanks in a new row, the original first row has the value showing. It is also creating an addition...
You've got carriage return and line feed characters in your data.
That will be causing you issues in your split.
Go back to the step BEFORE the split, right click on the column and choose 'Transform' and 'Clean'.
This should remove any unnecessary white space.
Hopefully this will prevent what appears to be blank rows.
Can you please provide some sample data and Power Query code?
It is too difficult to solve with the detail provided.