Group and Transpose Datatable

Help
1

I have the following datatable with 2 columns

ABC  123  
ABC  456  
ABC  789  
DEF  234  
DEF  456  
GHI  567  
GHI  678

I would like to group on column 1 and transpose each group into its own column. For example, it would look like this after:

ABC   DEF   GHI  
123   234   567  
456   456   678  
789

I’ve scoured the internet, but can’t seem to phrase my question properly. Would definitely appreciate any guidance. Thanks!

2

For grouping, see this solution by Florent_Salendres

(modified) Group.xaml (10.7 KB)

And for the transpose,

I think these meet your requirements.

2 Likes
3

Hi Tuanxn, sorry for my english but i’m french so … :-/
Of course this topic is old, but i try to do exactly what you explain and i don’t find real solution in responses.
So, did you get the solution to your request? please if you have, could you give me the xaml ?
with all my thanks