i have around 100 text files. The files have questions and 3 choices. FIles are like below

ab001.txt -- contains question
ab001a.txt -- is the first choice
ab001b.txt ---is second choice
ab001c.txt --- is third choice

There are thousnad files like this.

now i want to insert them in sql or first may in excel like

First columns questions and other three columns as answers

First two characters are same for soom files , looks like it signifies osme category so around every 30 questioons have same first charaters

Any ideas