How to convert txt (with blocks of variable length) to a table

[FreemanZ]

Hi Community, 

I was trying to sort the kindle notes by booktitle. My notes look like:

booktitle1

AA

booktitle2

BB

CC

booktitle1

DD

booktitle1

EE

booktitle2

FF

or in table like:

booktitle1

AA

booktitle2

BB

CC

booktitle1

DD

booktitle1

EE

booktitle2

FF

I need to sort them by booktitle to a table like:

booktitle1

AA DD FF

booktitle2

BB CC EE

The tricky part is sometimes a note has multiple rows, like the BB CC note. 

 

Could anyone help with this challenge?

[ThxAlot]

Simple enough

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSsrPzy7JLMlJNVSK1YlWcnQEU3BRIzDXyQlMOTujSkK0uLhgE3V1xWaQm5tSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Note = _t]),

    Grouped1 = Table.Group(Source, "Note", {"grp", Table.Skip}, 0, (x,y) => Byte.From(Text.Contains(y, "title", Comparer.OrdinalIgnoreCase))),
    #"Sorted Rows" = Table.Sort(Grouped1,{{"Note", Order.Ascending}}),
    Grouped2 = Table.Group(#"Sorted Rows", "Note", {"aggr", each Table.Combine([grp])[Note]}, 1),
    #"Combined Columns" = Table.CombineColumns(Grouped2, Table.ColumnNames(Grouped2), each {_{0}} & _{1}, "Notes"),
    #"Expanded Notes" = Table.ExpandListColumn(#"Combined Columns", "Notes")
in
    #"Expanded Notes"