I have a form response sheet with different columns. I have a region column for every country. But when you respond to the form you have to select only one country. So in my sheet every row has only one country column filled. I would like to filter every row (and populate to automatically have new responses filtered) to have a new column with the region selected.
Sheet expected In this case I only have 3 countries but in the real case I have about 40 countries.
Thanks for your help
try on row 1:
=ARRAYFORMULA(TRIM(TRANSPOSE(QUERY(TRANSPOSE(A:C);;999^99))))