One Column data separated in import , how to merge again

[sdhn]

Hello All,

My source  excel spread sheet has a column for Account as below:

This is one column.

ACCOUNTS
A	10010	91000
A	10100	91000
A	10200	01801
A	10700	91000
A	10950	91000

After GET DATA onto dashoard it is displaying as:

Data distriubuted into three columns.

ACCOUNTS	Column 3	Column 4
A	10010	91000
A	10100	91000
A	10200	01801
A	10700	91000
A	10950	91000

How to make column as source or merge onto one column ACCOUNTS ?  

[parry2k · Accepted solution]

@sdhn add a new column in PQ, and then remove other 3 columns, and make sure column 3 and column 4 data type is text before you add new column

New Account = 
[Account] & [Column 3] & [Column 4]

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[v-angzheng-msft · Accepted solution]

Hi, @sdhn 

In fact, parry2k  has already given the solution above and it will work. Let me add details to the above solution. Please see the screenshot below. In PowerQuery, hold down the Ctrl key to select the three columns above, and click Merge Columns in the right-click menu, then you can  select the separator and name the new column.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@sdhn add a new column in PQ, and then remove other 3 columns, and make sure column 3 and column 4 data type is text before you add new column

New Account = 
[Account] & [Column 3] & [Column 4]

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@sdhn understood, but I think you didn't get my last reply what I'm trying to say? Did you get it?

[parry2k]

@sdhn well if combining these 3 makes a unique account number then better to merge it, as you will be creating a relationship with other tables which will have a combined account number. In my opinion, it should e merge. Once you loaded it in PQ, you can merge it in PQ but if you can merge at source, like in SQL server, then do it there, it depends on the data source. If your data source is Excel, and you always receive raw data in 3 columns, instead of changing excel file, better to do in PQ so that you don't have to make changes to the excel file manually and this merging is taken care by PQ.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[sdhn]

I am using Power BI Desktop to develope a dashboard. 

[parry2k]

@sdhn do you have data in 3 different columns in Excel?

[sdhn]

yes, I have data in 3 different columns but under one heading.  Thanks 

[sdhn]

Yes , I noticed.

They are 3 different columns in Spread Sheet Under Heading called "ACCOUNTS".

what is good? To keep saparte or merge as it is SS.  If , merge how?

 I will have multiple months of data.