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.
Thanks for your help there that worked a treat
Awesome, glad we got there in the end.
If you could 'Accept as Solution' on the post that solved this for you, that'd be appreciated.