cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How can I transpose 2 dimensions data to rows

Hi everyone, I'm sorry for my bad English. I've tried to find the solution for this but didn't work so I post this message for your help.

I have this data:

 

Name  

   a           11/1     12/1     13/1

                 a1         a2        a3

   b           1/2        2/2      3/2

                 b1         b2        b3

   c           2/1        3/1      4/1

                 c1         c2        c3

What I'm looking for

a   11/1  a1 

a   12/1  a2

a   13/1  a3

b   1/2   b1

b   2/2   b2

b   3/2   b3

c   2/1   c1

c   3/1   c2

c   4/1   c3

 

I would like to say thanks in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
Super User V

Re: How can I transpose 2 dimensions data to rows

Hi @huynq 

 

Try this script or see the attached for the solution.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

View solution in original post

2 REPLIES 2
Highlighted
Super User V
Super User V

Re: How can I transpose 2 dimensions data to rows

Hi @huynq 

 

Try this script or see the attached for the solution.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

View solution in original post

Highlighted
Frequent Visitor

Re: How can I transpose 2 dimensions data to rows

Hi @Mariusz 

 

I'm sorry for my late reply.

Thank you for your solution. It works like a charm. 

 

 

Helpful resources

Announcements
Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors