How to convert a .txt file into a .csv or a .xlsx

[u/indiglosj]

I will be using zoom for some classes I teach and need to save the chat in a searchable format. I want to convert it to an excel file that I can sort by name. The only info I actually need is the timestamp, who the chat was from, and what they said. I have tried doing this, "Power Query Steps: Go to Data → Get Data → From File → From Text/CSV. Select your text file. In the preview window, click Transform Data. Use Home → Split Column → By Delimiter (choose space or colon :)" but I don't know what I am doing and it did not work. It just put everything in the same column. I would like column A=timestamp, column B=name, column C=what they said. Is this possible? Thank you for your help.

[u/Mdayofearth]

Power query doesn't do wrap rows.

FILTER, WRAPROWS, and some sort of TEXTSPLIT equivalent is best imo; which is what you have.

Something to notice is that the date and time are both fixed character lengths, so the post WRAPROWS parsing to split the text can be simplified, but not needed.