Merge 3 column into 1 row

---

MeBlank wrote:

Hi all,

 

I am new to Power BI and in need of help. I have a set of data which i would like to like to merge them into 1 column with multiple rows.

 

 

Name       Rank        ID             Score

ABC           2            123            95

DEF           5             456            56

 

 

I would like it to be:

Name     Score
ABC         

2               95                                          ROW 1

123

--------------------------------------------------------------------

DEF

5              56                                           ROW 2

456

--------------------------------------------------------------------

 

I need the data to be presented in such in dashboard actually. But I can't make it work. 

I'm not sure if this is doable. Need some advice. 

Thanks guys.

 

---

MeBlank

In Power BI, the doable equivalent would be creating a calculate column as below.

Name_ = Table1[Name]&CONCATENATE("_",Table1[Rank])&CONCATENATE("_",Table1[ID])