3

I have a sheet like this:

enter image description here

I want it to have two columns: in and out with the corresponding values:

enter image description here

I'm able to do so using sorting and copy-pasting, but as the data gets more complicated this way gets more complicated, and less safe, as well. Maybe there is a simple, correct way for such a transformation?

Improve this question
2
  • +Valentin, On second thought, it might be better to use SUM(C). If you agree, I will edit my post.
    – Jacob Jan Tuinstra
    Jul 9, 2016 at 9:26
  • @JacobJanTuinstra yeah - I used SUM on my own :-)
    – Valentin Golev
    Jul 11, 2016 at 16:11

1 Answer 1

Reset to default
2

You can use the following QUERY to obtain the result you want.

Formula

=QUERY(A1:C6, "SELECT A, MAX(C) GROUP BY A PIVOT B")

Screenshot

enter image description here

Example

I've created an example file for you: Transpose only one column in Google Spreadsheets

Improve this answer
0

Your Answer

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

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