Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gauravnarchal
Post Prodigy
Post Prodigy

Rearrange data table

Hello

 

How can I arrange my data from

 

Description2220583580380104
NI POS SETT 260222 200000812- 9806.23233.1211.65-10051.009806.23
NI POS SETT 270222 200000812- 10171.66234.6011.74-10418.0010171.66

 

to below

 

Account Description Amount
22205NI POS SETT 260222 200000812- 9806.23233.12
835NI POS SETT 260222 200000812- 9806.2311.65
803NI POS SETT 260222 200000812- 9806.23-10051.00
80104NI POS SETT 260222 200000812- 9806.239806.23
22205NI POS SETT 270222 200000812- 10171.66234.60
835NI POS SETT 270222 200000812- 10171.6611.74
803NI POS SETT 270222 200000812- 10171.66-10418.00
80104NI POS SETT 270222 200000812- 10171.6610171.66

 

 

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

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:

Pragati11_0-1649082231136.png

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

Pragati11_1-1649082334144.png

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

Pragati11_2-1649082431470.png

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:

Pragati11_3-1649082530561.png

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

Pragati11_4-1649082605286.png

This is the desired result. Hope this helps.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

7 REPLIES 7
Pragati11
Super User
Super User

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:

Pragati11_0-1649082231136.png

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

Pragati11_1-1649082334144.png

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

Pragati11_2-1649082431470.png

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:

Pragati11_3-1649082530561.png

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

Pragati11_4-1649082605286.png

This is the desired result. Hope this helps.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

HI @gauravnarchal ,

 

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

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11  - Done 🙂 

HI @gauravnarchal ,

 

Thanks! 🙂

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hello,

 

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

 

!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors