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.
I don't think I'm going to be able to troubleshoot like this. If you can share the Excel file and PBIX file I may be able to work it out.
Possibly, before the fill down step, click in one of the empty cells, right click and choose 'Replace Values' , enter null in the second box, then do the fill down after that step.
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
Thanks for your help there that worked a treat
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.
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.