Forum Discussion
How to pivot and display multiple values
Hi Anonymous ,
I am always up for improved solutions, but in this case I'm wondering why.
My pivot solution isn't only faster to implement but will also run faster when executed. Or am I missing something here?:
I put this gif together to walk you through the steps to get to this result. I started with a group by. I knew tables could be converted to lists and then concatenated but couldn't remember how so I found some good info here (See reply by Marc Pincince ) to parse the grouped names into a concatenated list. From there it was a series of pivot/unpivots and cleanup.
Hi Anonymous ,
I am always up for improved solutions, but in this case I'm wondering why.
My pivot solution isn't only faster to implement but will also run faster when executed. Or am I missing something here?:
Wasn't trying to say your solution isn't better. There is usually more than one way, I just shared the way I came up with. If yours is faster and better then the joxe should go with it. Doesn't hurt my feelings
I am very grateful to everyone for your solutions. I have used ImkeF's because it seemed the easiest to implement, and it has been great for me. Many thanks.
