Google Spreadsheet Table into a single column with dropdown

57 Views Asked by At

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

1

There are 1 best solutions below

2
On BEST ANSWER

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

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

enter image description here