Forum Discussion
Splitting Column into Rows Blank Value Affects Realtionship
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.
If i go into each cell and replace the value if(name) with the actual word to remove the blank the relationship is fine ad the table visual shows everything. So the issue is that the splitting is moving it to blank cells although if clicking on the blank cell the data is there
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.