Formula assist in office 365

SergeiBaklan 

Could you pease advice regarding the error in formula with the attached sheet

Hi Hussein_Mohamed , I'm not sure how you are familiar with Power Query, thus in general way.

- first is data source. I named the range in sample file as "data" and query it. However, if your source is txt or csv file you may query it directly

- we skip first 5 rows in data. If data structure is not fixed it'll be more reliable to find the position of "Book date" in first column and skip rows before that position

- apply headers from the first column and filter Description on <> null

- fill down all columns, it fills all nulls with above values

- select all columns except Description and Group By on them. In UI from Group By select in Operation->Aggregation All Rows

- in formula bar replace "each _ table = [...]" on "each [Description]". Let assume the aggregation column is called "Comment".

- you will see the List in Comment column

- click on right icon in that column and select Extract values

- in prompt select equal sign as delimiter (or whatever you prefer)

- select Comment column -> Split Column -> split it using "=" as delimiter.

Above is bit hard coded variant, to make it more flexible bit more of M-code is required.