Forum Discussion
Move Data into one cell with identifier
Hi. Thanks for any help. I need to send about 600 letters based on this data with about 5000 rows in total. Within the letter is a table for me to enter the service data and explain how its being ...
Hi robscheerger
Please correct me if I'm wrong, you are trying to combine rows of unique customer into one row.
If you have office365 you can use the new filter function to do that and join the text using textjoin. if you wish to make it unique then use unique function.. sample file attached > check working sheet2
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more