구글스프레드시트로 해봤습니다 (잘 모르는 정규식 활용)

=WRAPROWS(SPLIT(REGEXREPLACE(REGEXREPLACE(B2,"(\d+)개","$1"),"(\d+)원","$1")," "),3)

​

정규식을 사용하지않고

=ArrayFormula(let(w,wraprows(split(B2," "),3), hstack(choosecols(w,1),substitute(choosecols(w,2),"개",""),
substitute(choosecols(w,3),"원",""))))

=LET(rng,REGEXREPLACE(REGEXREPLACE(B2,"(\d+)\s*개","$1"),"(\d+)\s*원","$1"),
xSS,TRIM(SUBSTITUTE(rng,CHAR(10)," ")), xTS,TEXTSPLIT(xSS," "), Ary,WRAPROWS(xTS,3),
IFERROR(--Ary,Ary))

D2=IFERROR(--MID("#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2),FIND({"#"," ","개"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))+1,FIND({" ","개","원"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))-FIND({"#"," ","개"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))-1),MID("#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2),FIND({"#"," ","개"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))+1,FIND({" ","개","원"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))-FIND({"#"," ","개"},"#"&IFERROR(RIGHT($B$2,LEN($B$2)-FIND("@",SUBSTITUTE($B$2,"원","@",ROW($A$2:$A$11)-2))),$B$2))-1))

=IFERROR(--IFERROR(TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," "," ")," "," ")," "," "),"개 ","개"),{" ","개"},"원"),""), IFERROR(TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," "," ")," "," ")," "," "),"개 ","개"),{" ","개"},"원"),""))

=LET(X, WRAPROWS(REGEXEXTRACT(CHAR(10)&B2, CHAR(10)&"\D+|\d+(?!개원)", 1), 3),
  IFERROR(X*1,X) )

​

=LET(t, WRAPROWS(REGEXEXTRACT(B2, "\b[가-힣]+|\d+", 1), 3), IFERROR(--t, t))

​

=LET(a,REGEXEXTRACT(TEXTSPLIT(TRIM(B2)," ",CHAR(10)),"\b[가-힣]+|\d+"),IFERROR(a*1,a))

=HSTACK(TOCOL(REGEXEXTRACT(B2,"\b[가-힣]+",1)),
--WRAPROWS(REGEXEXTRACT(B2,"\d+",1),2))

​

힌트 : 열분할 - 비숫자 대 숫자로