Help with formula to get all values from stacked data

[Fractalis]

Hi to all,

I have the data below that appears in stacked way and that has FDGNUM values within a block of info named "ABC Data" and others
FDGNUM in a block named "XYZ Data". I´d like to extract the values of FDGNUM for each block and concatenate them separated by commas.

The output would be as shown in D1 and D2 for ABC Data and XYZ Data respectively.

Is there a way to get this answer with Excel 365 Formula?

"Crrb conf"

KKI = 4

MMSKS = BLAH BLAH

"ABC Data"

CHR_GLOBAL = NONE

ANUM = 32

CHR = NORMAL

FDGNUM = 43

MNQOS = 120

ANUM = 53

CHR = NORMAL

FDGNUM = 290

MNQOS = 106

ANUM = 3

CHR = NORMAL

FDGNUM = 115

MNQOS = 106

"XYZ Data"

CHR_GLOBAL = NONE

MAXOPI = 67295

MAXOPE = 4967295

ANUM = 8

FDGNUM = 11

DEFAULTAPN = TRUE

WILDCARDAPN = FALSE

ANUM = 9

FDGNUM = 79

DEFAULTVAL = FALSE

WILDCARDVAL = FALSE

"RRB info"

HJY = Blah Blah Blah

PPTW1JY = Blah Blah Blah

 

[JGordon11]

=LAMBDA(Range, LET(a, FILTER(Range, ISNUMBER(SEARCH("""",Range))+ISNUMBER(SEARCH("FDGNUM",Range))),
x, VSTACK(DROP(a,1),""),
b, FILTER(a, (LEFT(a,1)="""")*(LEFT(x,6)="FDGNUM")+(LEFT(a,6)="FDGNUM")),
c, IF(LEFT(b,6)="FDGNUM", RIGHT(b,LEN(b)-9),b),
d, TEXTJOIN(", ",1, c),
e, DROP(TEXTSPLIT(d,""""),0,1),
f, IF(LEFT(e,1)=",", RIGHT(e, LEN(e)-1),e),
g, WRAPROWS(f,2),
h, IF(RIGHT(g,2)=", ", LEFT(g,LEN(g)-2),g),
VSTACK({"Block","FDGNUM"},TRIM(h))))

 

[Fractalis]

=LAMBDA(Range, LET(a, FILTER(Range, ISNUMBER(SEARCH("""",Range))+ISNUMBER(SEARCH("FDGNUM",Range))),
x, VSTACK(DROP(a,1),""),
b, FILTER(a, (LEFT(a,1)="""")*(LEFT(x,6)="FDGNUM")+(LEFT(a,6)="FDGNUM")),
c, IF(LEFT(b,6)="FDGNUM", RIGHT(b,LEN(b)-9),b),
d, TEXTJOIN(", ",1, c),
e, DROP(TEXTSPLIT(d,""""),0,1),
f, IF(LEFT(e,1)=",", RIGHT(e, LEN(e)-1),e),
g, WRAPROWS(f,2),
h, IF(RIGHT(g,2)=", ", LEFT(g,LEN(g)-2),g),
VSTACK({"Block","FDGNUM"},TRIM(h))))

Thanks for answer. I receive #CALC!. Where should be entered the range A1:A35 within the formula?

 

[JGordon11]

Go to Formulas->Define Name set Name: to FDGNUM, set Refers to: to the code I posted. Then type =FDGNUM(A1:A35) in a cell and you should get the result you're looking for.

 

[Fractalis]

Go to Formulas->Define Name set Name: to FDGNUM, set Refers to: to the code I posted. Then type =FDGNUM(A1:A35) in a cell and you should get the result you're looking for.

Thank you. It works great. I haven´t use this LAMBDA function before,