Transpose and concantenate

[Eric Ayoola]

Dear all,

How do I trasponse and concantenate multiple values for specific items so that each item has its transposed and concantenated values attributed to it in another list.

For example, if say we have undertaken various assessments with multiple outcomes for each assessment and I would want to return each assessment and the outcomes (delimited by commas) in single rows per assessment.

Please see attached file.

Many thanks.

 

[Luke M]

Hi Eric, and welcome to the forum!

Sadly, there's no native function in XL that can do this, due to XL's poor concatenate function. However, you can use a user defined function (UDF) that can do this. Check out Hui's comment here:
http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/#comment-958816

You can scroll up and read the main article if you need help on installing a UDF.