In Google Sheets, what formula can I use to convert columnar data to multiple rows, with a "group" in column A?
You may try:
={tocol({A3:A14,A3:A14}),tocol(B3:C14)}