Transfer the table from vertical to horizontal

[harryli]

Dear all, 

I would like to transfer the table from vertical to horizontal, like the following:

to be like:

Today Discharge | data*n

[v-shex-msft]

Hi @harryli,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[PC2790]

Hey @harryli ,

You can try Power Query for the same:

Steps to be followed:

1) In Power Query --> Home --> Use Header as First Row

2) And then in Transform section, click on Transpose option

The outcome will be something like below:

Started from:

Outcome as:

See if it caters to your requirement

[harryli]

I think my situation is not like this.

I just wanna transform the display table.

from:

abc

1,2,3

to

abc|1, 2, 3

[harryli]

Today Discharge|A1001 A1002 …

or
Today Discharge|A1001, A1002, etc.

I would like to transfer like the above.

Thanks

[SpartaBI]

@harryli you want it as a measure? as a new table? I need more info :))
P.S. will appreciate your kudos while we getting there 😀

[harryli]

transfer to the following, the format is table/matrix:

[SpartaBI]

@harryli can you give more details? Not sure I understood.
Also, will be good to share a sample file of your requirement