Google Sheets 转置 – 在每隔一列中返回所有数据

huangapple go评论66阅读模式
英文:

Google Sheets Transpose - return all data in every other column

问题

我正在使用=transpose(filter('Top HP''s List'!A:A, (search("-P/TT", 'Top HP''s List'!A:A))))来搜索一列文本,对其进行筛选,然后将其转置为一行。

有没有办法将其转置到每一行的其他列?
例如,使用列A,留下列B为空白,使用列C,留下列D为空白,以此类推。

谢谢
Jon

使用=transpose(filter('Top HP''s List'!A:A, (search("-P/TT", 'Top HP''s List'!A:A))))
在转置行的每一列中获取一个值。

希望在转置行的每隔一列中获取一个值。

英文:

I am using =transpose(filter('Top HP''s List'!A:A, (search("-P/TT", 'Top HP''s List'!A:A)))) to search a column for text, filter it, and then transpose it to a row.

Is there any way to transpose to every other column in the row?
eg, use Col A, leave Col B blank, use C, leave D blank, use E, etc etc.

Thanks
Jon

Using =transpose(filter('Top HP''s List'!A:A, (search("-P/TT", 'Top HP''s List'!A:A))))
Getting a value in every column of the transposed row.

Would like a value in every other column of transposed row

答案1

得分: 0

可以使用:

=LET(data,转置(筛选('Top HP's List'!A:A, (搜索("-P/TT", 'Top HP's List'!A:A)))),
IFNA(缩减(TOROW(,1),序列(列数(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),)))))
英文:

> Is there any way to transpose to every other column in the row? eg, use Col A, leave Col B blank, use C, leave D blank, use E, etc etc.

You can use:

=LET(data,transpose(filter('Top HP''s List'!A:A, (search("-P/TT", 'Top HP''s List'!A:A)))),
IFNA(REDUCE(TOROW(,1),SEQUENCE(COLUMNS(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),)))))

huangapple
  • 本文由 发表于 2023年7月23日 18:44:57
  • 转载请务必保留本文链接:https://go.coder-hub.com/76747812.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定