How to create a table using partial data from two row

Hello I have a table that has data from two sources but have same ID

ID A B C D 123 xyz xxy xxd xxa 123 abc abd def xxr

I want to create a table that uses partial data from both rows

123 xyz xxy def xxr

How can i Do this?