Merge 3 column into 1 row

[MeBlank]

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.

[Eric_Zhang · Accepted solution]

---

@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])

[MeBlank]

I guess I have to go with this method. Or maybe use individual cards to display the data.

Thank you for the help.

[CahabaData]

well this is just thinking out loud; 

* make a dupe calculated table with just Rank, Score columns (table 2)

* delete Score column from table 1

* transform table 1 to single column 

* join table 2 to transformed table 1 on Rank field