1

I'm trying to select a row of data from my table based on text in columns A and B and then transpose it into a column. In my example, I would like to just have Minnie Mouse's information in a single column. I'm able to accomplish this in 2 steps, by first transposing the data and then filtering it (circled in my image), however I'd like to do it in a single step. I've tried combining the TRANSPOSE and FILTER functions but I always get an error. I was able to use QUERY and "select" but that only returned the name, "Minnie" and not the rest of her information. Link to sample sheet enter image description here

1 Answer 1

0

You should be filtering first, then transposing. Almost all spreadsheet functions expects data to be found in a single row, as this is how the convention works. I'll be using the corrected references.

Using the FILTER function:

=TRANSPOSE(FILTER(A2:E6,A2:A6=G3,B2:B6=H3))
4
  • Thanks for the suggestion, David Tan. I think that might be one of the variations I already tried. I just tried plugging it in and gave me and #N/A error (no matches) Commented Dec 3, 2022 at 14:04
  • Hm, strange. Mind sharing a link to your spreadsheet? That will help immensely here.
    – David Tan
    Commented Dec 4, 2022 at 12:34
  • Thanks, David. The link is in the original post. Commented Dec 5, 2022 at 0:12
  • I have it working on my end now. the cell references were off, so I shifted them by down.
    – David Tan
    Commented Dec 5, 2022 at 2:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.