merge and allign the sentence in a cell

[ExcelNewbie2020]

sirs,
i have a long range of column with morethan 2000 cells, would it be possible to merge those sentence in a single cell then reallign. Please see table in column E for reference..

Book1
	A	B	C	D	E
1	name	date	dept.	section	particulars
2	name1	01-03-23	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above)
3					The list is stored for each date and reflected in the calendar
4					This Excel template is created using Excel functions and VBA
5	name4	03-03-23		IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people)
6					This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity
7					It helps you divide tasks into categories based on Importance and Urgency.
8	name7	02-03-23		IT1	YourDictionary strives to make learning as stress-free as possible
9					no matter what your age or understanding is
10					And our sentence examples are no different
11					You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List
12
13
14
15
16	expected result
17	name1	01-03-23	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above) The list is stored for each date and reflected in the calendar This Excel template is created using Excel functions and VBA
18	name4	03-03-23	IT	IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people) This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity It helps you divide tasks into categories based on Importance and Urgency.
19	name7	02-03-23	IT	IT1	YourDictionary strives to make learning as stress-free as possible no matter what your age or understanding is You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List And our sentence examples are no different
Sheet1

 

[JvdV]

Can you explain in a bit more detail how dept. is filled down? Is it always going to be the section minus the trailing numbers for example?

 

[ExcelNewbie2020]

Can you explain in a bit more detail how dept. is filled down? Is it always going to be the section minus the trailing numbers for example?

my bad..dept should not filled down.. what do you mean "the section minus the trailing numbers".. i see, the section, can be a word without a number..

 

[JvdV]

Question.xlsx
	A	B	C	D	E
1	name	date	dept.	section	particulars
2	name1	1-3-2023	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above)
3					The list is stored for each date and reflected in the calendar
4					This Excel template is created using Excel functions and VBA
5	name4	3-3-2023		IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people)
6					This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity
7					It helps you divide tasks into categories based on Importance and Urgency.
8	name7	2-3-2023		IT1	YourDictionary strives to make learning as stress-free as possible
9					no matter what your age or understanding is
10					And our sentence examples are no different
11					You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List
12
13	name	date	dept.	section	particulars
14	name1	44986	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above) The list is stored for each date and reflected in the calendar This Excel template is created using Excel functions and VBA
15	name4	44988		IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people) This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity It helps you divide tasks into categories based on Importance and Urgency.
16	name7	44987		IT1	YourDictionary strives to make learning as stress-free as possible no matter what your age or understanding is And our sentence examples are no different You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List
Sheet11

Cell Formulas
Range	Formula
A13:E16	A13	=LET(x,SCAN("",A2:A11,LAMBDA(a,b,IF(b="",a,b))),r,FILTER(IF(A2:D11="","",A2:D11),A2:A11<>""),REDUCE(A1:E1,TAKE(r,,1),LAMBDA(y,z,VSTACK(y,HSTACK(XLOOKUP(z,TAKE(r,,1),r),TEXTJOIN(CHAR(10),,FILTER(E2:E11,x=z)))))))
Dynamic array formulas.

 

[ExcelNewbie2020]

Question.xlsx
	A	B	C	D	E
1	name	date	dept.	section	particulars
2	name1	1-3-2023	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above)
3					The list is stored for each date and reflected in the calendar
4					This Excel template is created using Excel functions and VBA
5	name4	3-3-2023		IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people)
6					This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity
7					It helps you divide tasks into categories based on Importance and Urgency.
8	name7	2-3-2023		IT1	YourDictionary strives to make learning as stress-free as possible
9					no matter what your age or understanding is
10					And our sentence examples are no different
11					You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List
12
13	name	date	dept.	section	particulars
14	name1	44986	IT	IT1	A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above) The list is stored for each date and reflected in the calendar This Excel template is created using Excel functions and VBA
15	name4	44988		IT1	This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people) This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity It helps you divide tasks into categories based on Importance and Urgency.
16	name7	44987		IT1	YourDictionary strives to make learning as stress-free as possible no matter what your age or understanding is And our sentence examples are no different You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List
Sheet11

Cell Formulas
Range	Formula
A13:E16	A13	=LET(x,SCAN("",A2:A11,LAMBDA(a,b,IF(b="",a,b))),r,FILTER(IF(A2:D11="","",A2:D11),A2:A11<>""),REDUCE(A1:E1,TAKE(r,,1),LAMBDA(y,z,VSTACK(y,HSTACK(XLOOKUP(z,TAKE(r,,1),r),TEXTJOIN(CHAR(10),,FILTER(E2:E11,x=z)))))))
Dynamic array formulas.

the formula is overwhelming but it works.. many thanks sir..