How do I convert this text file to a csv file and have it ordered in the csv file by column3?

This is the text file.

column1: Mr

column2: Mark

column3: Spencer

column4: Green

column5: 5

column6: Milk

column1: Miss

column2: Jenny

column3: Hill

column4: Blue

column5 : 7

column6: Bread

This is the csv file (I don't know how to show it here as a grid). How do I convert the text file to this, ordered by column3 in the text file?

Hill Jenny Miss Milk Green 5

Spencer Mark Mr Bread Blue 7

by oneblack1 via /r/csharp

Leave a Reply