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 67…

Group and Transpose Datatable

farhan94 (Farhan Salam) December 16, 2018, 6:05am 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

Topic		Replies	Views
Converting a column data into row Help	5	1555	August 16, 2019
How to group by multiple columns from a datatable Activities datatable , excel , activities , question	5	7171	December 23, 2020
Transpose in Excel by Rules Help excel , activities , question	3	1623	January 8, 2020
Group two columns Help orchestrator , activities , studio	11	1417	August 3, 2019
How to group rows and transpose them to columns Help	5	2369	May 6, 2019