Forum Discussion
Moving text data in next column
Hi Team,
In power query editor, how to move text data into next column as it seems the data for a particular row is not appering in the correct column.
Regads,
Niraj
Hi raj5714
When your data appears in the wrong columns, here are several methods to fix this in Power Query Editor:
1. Split Columns by Delimiter (Best for Consistent Patterns)
Select the column with misaligned data
Go to Transform tab → Split Column → By Delimiter
Choose the appropriate delimiter (comma, tab, space, etc.)
Select At each occurrence or At left-most/right-most delimiter as needed
Click OK and rename the new columns
2. Extract Text to New Columns (For Position-Based Issues)
Select the problem column
Use Extract options in the Transform tab:
Text Before Delimiter
Text After Delimiter
Text Between Delimiters
First Characters/Last Characters (for fixed-width data)
3. Use Replace Values to Fix Specific Cases
Right-click the column → Replace Values
Enter the text pattern that's appearing in the wrong column
Replace with blank or the correct value
4. Conditional Column for Complex Cases
Go to Add Column → Conditional Column
Set up rules like: "If ColumnA contains 'wrongtext' then ColumnB else ColumnA"
5. Transpose Then Reorganize (For Severe Misalignment)
Select Transform → Transpose
Reorganize the data as needed
Transpose back to original orientation
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
5 Replies
Hi raj5714 ,
If the text is in the wrong column due to a delimiter shift (like comma, space, etc.):
Select the column with misplaced text.
Go to Home > Split Column > By Delimiter.
Choose the appropriate delimiter (e.g., space, comma).
Select Split into Columns.
Hi raj5714 ,
Just following up on your query about moving text data to the next column. BhavinVyas3003 has provided a response that may address your concern.If his solution worked for you, please consider marking it as the Accepted Answer — this helps others in the community who might have the same question.
If you're still experiencing issues or need further clarification, feel free to add more details we’re here to help!
Thanks again for being part of the Microsoft Fabric Community!
Hi raj5714
When your data appears in the wrong columns, here are several methods to fix this in Power Query Editor:
1. Split Columns by Delimiter (Best for Consistent Patterns)
Select the column with misaligned data
Go to Transform tab → Split Column → By Delimiter
Choose the appropriate delimiter (comma, tab, space, etc.)
Select At each occurrence or At left-most/right-most delimiter as needed
Click OK and rename the new columns
2. Extract Text to New Columns (For Position-Based Issues)
Select the problem column
Use Extract options in the Transform tab:
Text Before Delimiter
Text After Delimiter
Text Between Delimiters
First Characters/Last Characters (for fixed-width data)
3. Use Replace Values to Fix Specific Cases
Right-click the column → Replace Values
Enter the text pattern that's appearing in the wrong column
Replace with blank or the correct value
4. Conditional Column for Complex Cases
Go to Add Column → Conditional Column
Set up rules like: "If ColumnA contains 'wrongtext' then ColumnB else ColumnA"
5. Transpose Then Reorganize (For Severe Misalignment)
Select Transform → Transpose
Reorganize the data as needed
Transpose back to original orientation
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hi raj5714 ,
Just following up on your post about the Moving text data in next column
One of our community members,Elena_Kalina BhavinVyas3003 has already shared some helpful troubleshooting steps that might resolve the issue. If those steps helped fix the problem, we’d really appreciate it if you could mark the response as the Accepted Answer it highlights their support and assists others facing the same issue.
If you're still running into problems or need further help, feel free to respond with more details. We're here to assist you!
Thank You !!Hi raj5714 ,
Just following up one last time on your question about shifting text data into the correct column in Power Query Editor.
We haven’t heard back from you in a while. If the earlier response helped, please consider marking it as the Accepted Answer so it can assist others in the community facing a similar scenario.
If you're still encountering the issue, you're always welcome to create a new post with updated details we’ll be here to help.
Thanks again for being part of the Microsoft Fabric Community!
