Note: I cannot paste screenshot or developed application due to environment restrictions and confidentiality of data.
You can take the above table data as.
Load *,MakeDate(Right(D_MONTH,4),left(D_MONTH,2)) as DATE;
(html, codepage is 1252, embedded labels, table is @1, filters(
Remove(Row, Pos(Top, 1))