this function it brings all together but i wanted something like this
Text join will join all the cell values together like
[8th June, 9th June, 10th June, 11th June, 12 June, 13th June , , , 16th June, 17th june, 18th June, , , , 21st June, 22nd June, 23rd June]
but i wanted the result as
8th June to 13th June 16th June to 18th June 21st June to 23rd June.
as of now i am manually typing it, as i need to do this for a huge data