Concatenate Table By Value and Summarize Cell

[exc4libur]

Hi guys!

I am trying to:
1) concatenate table headers with there respective data inputs then,
2) summarize inside one cell all the data by person.

I've attached a book with an example made manually.

Thanks in advance!

 

[Nebu]

Hi:

Find the attached.

Array formula execute using control+shift+enter keys.

Thanks

 

[exc4libur]

Hi:

Find the attached.

Array formula execute using control+shift+enter keys.

Thanks

Hi Nebu!
Thank you for your time. However, I need to do this via vba.
I need to concatenate the respective header with the input and then summarize by person.

 

[Nebu]

Hi:

Sorry, I was busy with some other work, here is the file with the codes. click the run button to get the results.


Thanks

 

[exc4libur]

Hi:

Sorry, I was busy with some other work, here is the file with the codes. click the run button to get the results.


Thanks

Thank you Nebu