Google Spreadsheet Table into a single column with dropdown

Question

Please help me to sort this data in a single column with table headers as drop downs and when selecting the drop down menu appropriate data should be loaded below that header. enter image description here

Post data as text table so that we can copy or share a workbook. Also show what output you desire. — Harun24hr, Jun 11 '22 at 15:11
Welcome to [Stack Overflow](https://stackoverflow.com/tour). Also consider sharing a publicly editable [sample spreadsheet](https://webapps.stackexchange.com/a/138383/269219). — doubleunary, Jun 11 '22 at 15:15

score 0 · Accepted Answer · answered Jun 11 '22 at 15:28

0

There are few ways to do that. You can try INDEX()/MATCH() formula.

=INDEX(A3:C5,,MATCH(G2,A2:C2,0))

answered Jun 11 '22 at 15:28

Harun24hr

30,391
4
21
36

Thanks for help, If we need fetch data from another spreadsheet for the same result. Please help I googled a lot but no luck. – Gopakumar Jun 13 '22 at 09:09
Then you have to use `IMPORTRANGE()` function. – Harun24hr Jun 13 '22 at 09:15

Google Spreadsheet Table into a single column with dropdown

1 Answers1