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

Transform groups of columns into a single rows

Hi guys!

 

I want to create a solution that groups me, every 4 units for example and creates a simple row with those four units. I have this:

1.JPG

And i want this:

2.JPG

 

I have tried to use solutions like the pivot table, but I do not finish creating the definitive solution. Please help!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Transform groups of columns into a single rows

@Starshow solution attached.

 

 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




4 REPLIES 4
AClerk Established Member
Established Member

Re: Transform groups of columns into a single rows

Hi @Starshow 

Can you elaborate?
What is it you are trying to achieve?

Thanks!

Highlighted
Super User
Super User

Re: Transform groups of columns into a single rows

@Starshow solution attached.

 

 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




Super User
Super User

Re: Transform groups of columns into a single rows

Lovely solution @parry2k 

Starshow Frequent Visitor
Frequent Visitor

Re: Transform groups of columns into a single rows

you are amazing @parry2k , THANKS!!!