Extract cells values under conditions (ignore blank cells)

[smide]

Hello.

In column A (A1:A200) I have a cities, in column B shipping costs and in column C there is a 'mark' (letter "A") or a blank cell.

I need to extract values for each city only if there is a mark in that row (row with letter A in column C).

Column E is already populated with all cities (from column A) and results for each city should be placed in corresponding row(s) (from column F to column Z).

example.

	A	B	C	D	E	F	G
1	Toronto	45	A		Toronto	45	33
2	Melbourne	12			Melbourne	76	44
3	Melbourne	76	A		Vienna	96
4	Vienna	18
5	Toronto	9
6	Melbourne	44	A
7	Vienna	96	A
8	Toronto	33	A
9	Vienna	106

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	Toronto	45	A		Toronto	45	33
3	Melbourne	12			Melbourne	76	44
4	Melbourne	76	A		Vienna	96
5	Vienna	18
6	Toronto	9
7	Melbourne	44	A
8	Vienna	96	A
9	Toronto	33	A
10	Vienna	106
11
Sheet7

Cell Formulas
Range	Formula
F2:H4	F2	=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$2:$B$100)/($A$2:$A$100=$E2)/($C$2:$C$100<>""),COLUMNS($E2:E2))),"")

 

[JEC]

PQ solution (dynamic)

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    cTypes = Table.TransformColumnTypes(Source,{{"Column2", type text}}),
    fltr = Table.SelectRows(cTypes, each ([Column3] = "A")),
    grp = Table.Group(fltr, {"Column1"}, {{"Count", each Text.Combine(_[Column2],"|")}}),
    xMaxList =  List.Transform({
        1..List.Max(
         Table.AddColumn(grp, "Custom", each 
            List.Count(
                Text.PositionOfAny([Count], {"|"}, Occurrence.All)
            ))[Custom]
        ) +1
 
    }, each "V" & Text.From(_)),
    result = Table.SplitColumn(grp, "Count", Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), xMaxList)
in
    result

Test multilevel drop-down list.xlsx
	A	B	C	D	E	F	G	H	I
1	Column1	Column2	Column3			Column1	V1	V2
2	Toronto	45	A			Toronto	45	33
3	Melbourne	12				Melbourne	76	44
4	Melbourne	76	A			Vienna	96
5	Vienna	18
6	Toronto	9
7	Melbourne	44	A
8	Vienna	96	A
9	Toronto	33	A
10
Sheet2