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.
Thanks for that, it's making more sense to me now.
If you right click on the 'Chemistry Recommended' column and choose 'Fill >> Down' does this get you closer to what you want?
You'll probably need to add one more step to filter the blank rows you were seeing.
I have filled down and this has not changed the table and relationship data
Did filling down fill in the blanks or not?
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.