Moving text data in next column

[raj5714]

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

[Elena_Kalina]

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)

1. Select the column with misaligned data

2. Go to Transform tab → Split Column → By Delimiter

3. Choose the appropriate delimiter (comma, tab, space, etc.)

4. Select At each occurrence or At left-most/right-most delimiter as needed

5. Click OK and rename the new columns

2. Extract Text to New Columns (For Position-Based Issues)

1. Select the problem column

2. 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

1. Right-click the column → Replace Values

2. Enter the text pattern that's appearing in the wrong column

3. Replace with blank or the correct value

4. Conditional Column for Complex Cases

1. Go to Add Column → Conditional Column

2. Set up rules like: "If ColumnA contains 'wrongtext' then ColumnB else ColumnA"

5. Transpose Then Reorganize (For Severe Misalignment)

1. Select Transform → Transpose

2. Reorganize the data as needed

3. 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.

[v-aatheeque]

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 !!

[v-aatheeque]

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!

[BhavinVyas3003]

Hi @raj5714 ,

If the text is in the wrong column due to a delimiter shift (like comma, space, etc.):

1. Select the column with misplaced text.

2. Go to Home > Split Column > By Delimiter.

3. Choose the appropriate delimiter (e.g., space, comma).

4. Select Split into Columns.

[v-aatheeque]

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!