Need help in doing a cross tabor any other tool to make 2 columns in to rows

[MoinShaikBasha]

The example of the data is like below

Name  Value

A         ABCD

B        EFGH

C        IJKLM

D       NOPQ

A       ZYVX

C       1234

D       5678

I need the output in the below format

A          B         C          D

ABCD EFGH  IJKLM  NOPQ

ZYVX              1234    5678

[PhilipMannering · Accepted solution]

Hi @MoinShaikBasha 

Something like this?