Concatenating carriage returned values from 3 columns

[Legacy 226937]

Hey,

I have 100s of rows with cells similar to the table as shown below. Each field is described by it's coded value and it's related value description - linked by number. Each value in the coded value and value description field are separate by a carriage return (char 10) - I'd like to concatenate them to be as shown in the Desired Result column.

Field ID	Name of Field	Coded Values	Friendly Value	Value Definition	Desired Result: #) %Friendly Value% (%Coded Value%) - %Value Definition%
1	Field A	1) Y 2) N	1) Yes 2) No		1) Yes (Y) 2) No (N)
2	Field B	1) Abc 2) Bcd 3) EfA	1) Alpha Bravo Charlie 2) Bravo Charlie Delta 3) Echo Frank Alpha	1) Definition blah blah 2) Definition blah blah 3) Definition blah blah	1) description (Abc) - Definition blah blah 2) description (Bcd) - Definition blah blah 3) description (Bcd) - Definition blah blah

<tbody>
</tbody>

The number of values per cell vary - there could be no value or 50 values.

I'm not sure how to go about this exactly. I'm also welcome to suggestions. I was also thinking of separating values into individual rows per value then concatenating per row but then the challenge is how do I merge it again to look like the above. I would prefer this method if someone knows how.

Any help would be appreciated!

Thanks,

Jason

 

[Legacy 226937]

To clarify, field ID 1 is 1 row, field ID 2 is another row. The values are stored and separated by carriage return within the cell.