Move values in rows at the end of the preceding row *SOLVED*

[Norman]

Dear all,

I have an excelsheet where the dataset is store in column A in in a CSV format.
I am looking for a code starting from A1 to remove the rows with text string and to move some numbers stored in rows <>"2018" at the end of the previous row. I have posted a question in another thread to adress the text removing part but I am looking for the how to move the numbers <>2018 part.

s an example of the dataset:

Configurable Alerts
Report ID:
Run Date:
Run Time:
TEXT_SYS801
16/12/2018
22:30:49 UTC
Page 1 of 34
Enterprise Blablabla
78) Blablabla data blablabla by blabla (medium priority)
This alert gives bla bla bla bla to partners.
2018,...,...
2018, 1, 95716, 10021703, NA, TEXT (TEXT), PHL, TEXT,Text Text Text,
10031793, 2448.83
2018,...,...
3000.95
2018,...,...
2018,...,...

Configurable Alerts
Report ID:
Run Date:
Run Time:
TEXT_SYS801
16/12/2018
22:30:49 UTC
Page 2 of 34
2018,...,...
2018,...,...
2018,...,...

Any idea?

I have a put a question in the following thread to adjust the first part of the code but have not heard anything yet
http://www.excelfox.com/forum/showth...-on-Conditions

Many thanks for the help and sharing knowledge

Cheers
Norman