英文:
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),)))))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论