madocar Member Dec 18, 2016 #1 Hi everyone, I would like to ask you if it is possible to do this: According to date in column B (1.12.2016) I would like to get values from column C, merged to one cell separated by char(10). More in attachment. Thanks for any help Attachments chandoo.org - Multiple cells merged to one cell - array condition.xlsx 9.9 KB · Views: 4
Hi everyone, I would like to ask you if it is possible to do this: According to date in column B (1.12.2016) I would like to get values from column C, merged to one cell separated by char(10). More in attachment. Thanks for any help
bobhc Excel Ninja Dec 18, 2016 #2 Why do you want to merge your data, once merged you will not be able to use the data in any meaningful way. Can you not turn your data into a table and group by date?
Why do you want to merge your data, once merged you will not be able to use the data in any meaningful way. Can you not turn your data into a table and group by date?
madocar Member Dec 18, 2016 #3 Hi Bobhc, I need to put those merged values to the text box. That's why I need to make them merged. Thanks
Hi Bobhc, I need to put those merged values to the text box. That's why I need to make them merged. Thanks
B bosco_yip Excel Ninja Dec 18, 2016 #4 Hi, Here's a file in concatenate name with helper column formula way. Regards Attachments ConcatenateName.xlsx 10.7 KB · Views: 5
