Merging records in fields from duplicate records

[LwoodPDowd]

Generalized layout of data I'm working with

EdgeID NodeTo NodeFrom PubID Method

1 NodeA NodeB 100 X

2 NodeA NodeC 100 X

2 NodeA NodeC 101 Y

2 NodeA NodeC 102 Z

2 NodeA NodeC 102 W

2 NodeA NodeC 103 X

3 NodeB NodeC 105 Y

3 NodeB NodeC 105 W

3 NodeB NodeC 106 X

I want to concatenate these records by EdgeID but not lose the PubID or Method information.

The ideal solution would use "|" as a hash between the values entered in those fields.

For example

EdgeID NodeTo NodeFrom PubID Method

1 NodeA NodeB 100 X

2 NodeA NodeC 100|101|102|103 W|X|Y|Z

3 NodeB NodeC 105|106 W|Y|Z

I'm integrating many sources of similar data, one formated like the top, many more formated with the concatenated informatin from above.

I'll also be pulling in data from lots of table into one big final form, having this data threaded through multiple relational tables would be a pain.

Thanks