[퀴즈_64] 1문자씩 나누기

파워쿼리로 만들어 봅니다.
힌트 : Text.PadStart

=LET(rngCn,A1:A9, vDB,MAP(rngCn,LAMBDA(irng, TEXTJOIN(" ",,MAP(TEXTSPLIT(irng," "),LAMBDA(vspls, LET(mVals,IFERROR(REGEXEXTRACT(vspls,"^\d+(?=[가-힣])"),""),
IF(mVals="",vspls,TEXT(VALUE(mVals),"000")&RIGHT(vspls,LEN(vspls)-LEN(mVals))))))))), xMax,MAX(LEN(vDB)),
MAKEARRAY(ROWS(vDB),xMax,LAMBDA(iR,iC, IF(iC<=LEN(INDEX(vDB,iR)),MID(INDEX(vDB,iR),iC,1),""))))

띄어쓰기로 분리한후에 "0"을 앞에추가하여 4자리로 만들어 각각 분리하는 작업

=LET(DT, A1:A9,
DL, BYROW(DT,LAMBDA(r,TEXTJOIN(" ",FALSE,RIGHT("0000"&TEXTSPLIT(r," "),4)))),
MAX, MAX(LEN(DL)),  
DROP(REDUCE("",DL,LAMBDA(t,r,VSTACK(t,MID(r,SEQUENCE(1,MAX),1)))),1))

 

=LET(Area, A1:A9,
mData, MAP(Area, LAMBDA(m, TEXTJOIN(" ",,RIGHT("000"&TEXTSPLIT(m," "),4)))),
seq, SEQUENCE(, MAX(LEN(mData))),
MID(mData, seq, 1))