Rearrange data table

[gauravnarchal]

Hello

How can I arrange my data from

Description	22205	835	803	80104
NI POS SETT 260222 200000812- 9806.23	233.12	11.65	-10051.00	9806.23
NI POS SETT 270222 200000812- 10171.66	234.60	11.74	-10418.00	10171.66

to below

Account	Description	Amount
22205	NI POS SETT 260222 200000812- 9806.23	233.12
835	NI POS SETT 260222 200000812- 9806.23	11.65
803	NI POS SETT 260222 200000812- 9806.23	-10051.00
80104	NI POS SETT 260222 200000812- 9806.23	9806.23
22205	NI POS SETT 270222 200000812- 10171.66	234.60
835	NI POS SETT 270222 200000812- 10171.66	11.74
803	NI POS SETT 270222 200000812- 10171.66	-10418.00
80104	NI POS SETT 270222 200000812- 10171.66	10171.66

[Pragati11 · Accepted solution]

Hi @gauravnarchal ,

You can achive this simple in Power Query Editor in Power BI Desktop, by following the steps below:

This is the source data that you shared:

Now select your Description column --> under Transform --> select Unpivot Columns --> Unpivot other columns as shown below:

Onec you do this transformation, you will get the following:

This is nearly the required result you need.

Rename Attribute to Account and Value to Amount column names by right-clicking on the respective columns. This will give you the following:

Now just hold the Description column and drag it to the right, to get the expected output:

This is the desired result. Hope this helps.

[gauravnarchal]

@Pragati11  - Brilliant - Thank you for your help...

[Pragati11]

HI @gauravnarchal ,

Can you please mark the right solution to this thread rather than your response please?

[gauravnarchal]

Hi @Pragati11  - Done 🙂 

[Pragati11]

HI @gauravnarchal ,

Thanks! 🙂

[Pragati11]

HI @gauravnarchal ,

If the solution helped, appreciate a kudos and do accept it as a solution to this thread so that others can benefit from it on the forum.

[Datavizuserpbi]

Hello,

Make a transposition of your table and your column gonna become row .

!!