Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Need help to correct a syntax error in my power query formula

Admitedly I am new to Power Query, I am trying to cleanse an internal database full of duplicate entries. I'm currently stuck at this step to transform the data.  Problem: I'm encountering an "...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,

    Thanks for the solution ZhangKun  and jgeddes  offered, and i want to offer some mroe information for user to refer to.

    hello Anonymous , you can click the 'Accout Name' and 'Postcode' columns,  then click merged columns in 'Add column' tab

    Then select split them by using the space.

     

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

Thanks for the solution ZhangKun  and jgeddes  offered, and i want to offer some mroe information for user to refer to.

hello Anonymous , you can click the 'Accout Name' and 'Postcode' columns,  then click merged columns in 'Add column' tab

Then select split them by using the space.

 

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.