##### Transform Text

In Concat column, StoreRef and RefCode are concatenated using CONCAT() function.

In Prod column, Product and ProdName columns are concatinated using CONCAT() funcion.

In Trim column, Reference column is trimmed using TRIM() function.

In Substitute column, - is sunbstituted by ; in reference column using SUBSTITUTE() function

In Sub column, Nail is substituted by Box of Nail in ProdName column using SUBSTITUTE() function

Len column is the length of ProdName column using LEN() function

Left column returns the left number in Prod column using LEFT() function

Right column returns the right side letters of Prod column using RIGHT() and LEN() functions.

Mid column returns middle letters of Reference column using MID() function.

##### Transform Date

Subtract Date column is date difference between the next row and the current row using normal subtraction

Datediff column is date difference between the next row and the current row using DATEDIFF() function

Year and Month columns are year and month of each row using YEAR() and MONTH() functions

eomonth column is end day of the month of each row using EOMONTH() function

Weekday column is the weekday number of each row using WEEKDAY() function

Day of Week and the column next to it are weekday names (abbreviated and full name) using TEXT() function to convert date to weekday name.