I have tried text to column etc.
It seems the issue is with the last column - the value that should be in the last column goes onto the next row which when converted messes everything and you sit with the last column’s value sitting under the first column.
Please help!
What exactly are you doing? What does the data look like? Are you by chance trying to import CSV data? That by chance in its second-but-last column contains an embedded newline? And the filed content is not quoted? Please see also the guidelines for asking.
Oh and btw please don’t mark the question as wiki next time. Thanks.