Forum Discussion

VladMatao's avatar
VladMatao
Frequent Visitor
6 years ago
Solved

Merge rows that are wrongly formated

Hello,   As you can see from the picture I have some values in column 3 which should be in one row, instead they span over multiple. That transfer for instance. Is there a way to merge them? ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi VladMatao ,

     

    First create a new table which only contains column 3.

    Then go to edit queries>"Transform">"Transpose":

     

    "Add column">"Custom Column":

    Merge all the columns and use"&"to connect with them:

    Finally you will see:

    Citys which was put in multiple rows has been merged in one row.

     

    Best Regards,
    Kelly

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi VladMatao ,

 

First create a new table which only contains column 3.

Then go to edit queries>"Transform">"Transpose":

 

"Add column">"Custom Column":

Merge all the columns and use"&"to connect with them:

Finally you will see:

Citys which was put in multiple rows has been merged in one row.

 

Best Regards,
Kelly