Forum Discussion
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 additional row with no value, basically an extra row. I need and have a relations hip formed although as the first row has only the value showing it is showing only the products related to this. I have set the data to show items with no data.
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.
13 Replies
Can you please provide some sample data and Power Query code?
It is too difficult to solve with the detail provided.
does this assist?
Not really. Something that I don't have to re-type.
Just copy/paste data, not screenshot, and also copy/paste PQ code from the advanced editor (obfuscate any sensitive info).
