在谷歌工作表中每隔一行转置 [英] Transpose every other row in a google sheet

问题描述

我收到了一张格式错误的工作表，其中有数千条记录，其中 X 和对应的 Y 值位于下一行，而不是同一行和下一列.

是否有允许我复制更改行的功能?

所以...

A2进入B2，A3进入C2A4进入B3，A5进入C3

等

样本表位于

I've been given a badly formatted sheet where there are thousands of records with X and corresponding Y value in the following row rather than the same row and next column.

Is there a function that will allow me to copy altering rows?

So...

A2 goes into B2 and A3 goes into C2
A4 goes into B3 and A5 goes into C3

etc

A sample sheet is in https://docs.google.com/spreadsheets/d/1fB2rpVdJiTmp96sjGZiIYvKxEL9DLiK7W7QU8-4AN3A/edit?usp=sharing

I'd prefer a Google Sheet solution but excel is fine as well.

解决方案

delete everything in B2:C range and try:

={FILTER(A2:A, A2:A<>"", MOD(ROW(A2:A), 2)=0),
  FILTER(A2:A, A2:A<>"", MOD(ROW(A2:A)+1, 2)=0)}

这篇关于在谷歌工作表中每隔一行转置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！