BYROW and TEXTSPLIT

[sadath]

=BYROW(A1:A3,LAMBDA(X,TEXTSPLIT(X,",")))

this return #Calc! error on my below data (A1:A3)

LOCCODE,NAME,TRXDATE,TRXNO,GROSS_SALES,HDOPERATORCODE,HDOPERATORRECEIPTNO,PAYMENTTYPE,TRXSTATUS

JIB,RAWDHA REPL JEDDAH,01/01/2023 00:00:00,25272,46.95,L,2408083,2,0

JIB,RAWDHA REPL JEDDAH,01/01/2023 00:00:00,25265,33.04,L,2407958,2,0

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=DROP(REDUCE("",A1:A3,LAMBDA(x,y,VSTACK(x,TEXTSPLIT(y,",")))),1)

 

[sadath]

works excellent !!, thanks

 

[Fluff]

You're welcome & thanks for the feedback.