Merge 5 cells into one but keep all data?

Copper Contributor

I need to combine about 6 cells across but then keep all that date in the first cell by merging them. It is not keeping all the data/ 

0 Replies