#solved š„³š„³
Hi excel expert! Can anyone help me with spreadsheet formula here? Thank you in advance.
Helmi Hafiz Hashim refer image below for a solution.
ā¢ Formula used in cell D2
=INDEX(QUERY(SPLIT(FLATTEN(A2:A&"|"&MAP(B2:B,LAMBDA(m,IFNA(SPLIT(m,","))))),"|",0,0),"SELECT Col1,Col2 Where Col2!=''"))
Helmi Hafiz Hashim you are using Google Sheets and group is related with Excel, it will be helpful if you post queries related to Excel. And why have you deleted your previous posts?
Mayukh Bhattacharya oh yes, mine is related to google sheet. I thought it would be the same categories because most of the formulaes are the same š
I think I deleted the comment, not the post.
I deleted the comment because I want to change. But after that, I cant hit reply button again š„²
Helmi Hafiz Hashim before this there were three posts and one of them you have deleted. No all of the formulas in google sheets and excel are not same, Google sheet may have got updated with few of the formulas which works with excel but not all. Please note we have a track of who is posting what and when it has posted/deleted or edited.
Mayukh Bhattacharya oh my bad. Maybe I deleted the post by mistake. Because I did post the same question in different group. When one of the post got answer and no response from the other post, I delete the other post and leave the one with the answer so that everybody can see.
Helmi Hafiz Hashim i dont know which group you have posted but here the solution was given.
Helmi Hafiz Hashim please check below a solution has already been provided
Woww tq2. Been looking for that formulas for agesss š
what is your excel version?
NaBeel GonDal it google sheet.
=arrayformula(xlookup(sequence(counta(split(TEXTJOIN(",",1,M9:M11),","))),scan(0,byrow(split(M9:M11,","),lambda(n,counta(n))),lambda(x,y,x+y)),L9:L11,,1,1))