Can duplicated rows be merged into just one keeping all data?

[Axsom]

This may have been answered already but I haven't been able to find it anywhere...
I always have a difficult time trying to explain Excel issues and my data is not able to be shared.
I have multiple tables that I used 'Append' to bring them together to create one list. As it turned out there are a couple of records that have duplicated entries. Can they be merged with the entries already there?

Here would be an example:
Can ROWs [1 & 5] be merged into ROW "1"and [2 & 6] merged into ROW "3"

to become this

This is my first time posting in these forums, any help is very much appreciated...

 

[Matt Allington]

My guess is you could unpivot the columns other than source, then re-pivot again after.

 

[Axsom]

thank you for that - I was able to use that and got them lined up now...
Being new to using Power Query - I have to quit think like I'm still in just Excel... Honestly - I don't know how I didn't know about it until now... my spreadsheets will never be the same