Hey guys.
I have recently started to be emailed building consent lists each Monday, the sales team ideally need these sheets sorted by consent value which I can only do by deleting columns from I onward however this info is also needed. The sheet is partly merged by consent with multiple owners against each one which is why I currently have to delete columns I onwards. I can copy past information or use the concatenate formula easily enough to combine the information however this will not work as the year progresses and the data on the sheets increases substantially.
Any way to essentially do the concatenate formula but without having to go through each row typing it out.
The number of owners varies per consent so i cannot even just work off a basic rule, I have attached a pic of a demo sheet below.
Thanks.
I have recently started to be emailed building consent lists each Monday, the sales team ideally need these sheets sorted by consent value which I can only do by deleting columns from I onward however this info is also needed. The sheet is partly merged by consent with multiple owners against each one which is why I currently have to delete columns I onwards. I can copy past information or use the concatenate formula easily enough to combine the information however this will not work as the year progresses and the data on the sheets increases substantially.
Any way to essentially do the concatenate formula but without having to go through each row typing it out.
The number of owners varies per consent so i cannot even just work off a basic rule, I have attached a pic of a demo sheet below.
Thanks.