Help required in Converting Rows to Columns and add Column Headers

[Swaroopa]

Hi All,

There are multiple rows containing the data as mentioned below.
ABC CREATED_BY MMM
ABC LAST_MODIFIED_BY abdcefgh
ABC PRINCIPAL_MODIFY_DATE 00000011111111
ABC lastname adm
ABC uniquename ABC
DEF uniquename DEF
DEF LAST_MODIFIED_BY aaaaaaa
DEF CREATED_BY MMM
DEF PRINCIPAL_MODIFY_DATE 111111111111
DEF PRINCIPAL_CREATION_DATE 111111111111111111

I need to convert the above data in the below format.

CREATED_BY PRINCIPAL_CREATION_DATE LAST_MODIFIED_BY PRINCIPAL_MODIFY_DATE lastname uniquename
MMM abdcefgh 00000011111111 adm ABC
MMM 111111111111111111 aaaaaaa 111111111111 DEF

Can anyone help me in achieving the above requirement?

Regards,
Swaroopa

[Swaroopa]

As is format:

Attaching the screenshots.Format 1.JPG

Required format:

Required Format.JPG