Rows to columns

I have data like below

ID	Value
A	1
B	2
C	3
D	4
D	5
E	6

I Need output like this

ID	A	B	C	D	E
Value	1	2	3	4	6
Value	1	2	3	5	6

can any one help me on this

Data Investigation

Accepted answers

Please see below :

Attached the workflow,

Regards,

Split_20220829.yxmd

All comments

Please see below :

Attached the workflow,

Regards,

Split_20220829.yxmd

thanks @messi007 its working

Quick Links

Tags

This months top contributors

Hollingsworth 335