如何在Google表格中将矩形的单元格转换为一行的行/列? [英] How to convert a rectangle of cells to a row/column of cells in Google Sheets?

问题描述

我有一个范围为A1:T25的数据集，我希望它位于单个行或一列中.有25行和20列.我尝试了以下方法:

I have a dataset from range A1:T25 and I want this to be in a single row or column. There are 25 rows and 20 columns. I tried the following:

={A1:A25; B1:B25; C1:C25; D1:D25; E1:E25; F1:F25; G1:G5; H1:H25; I1:I25; J1:J25; K1:K25; L1:L25; M1:M25; N1:N25; O1:O25; P1:P25; Q1:Q25; R1:R25; S1:S25; T1:T25}

按Enter键后，我的数据会出现一列，但不知何故有480个单元格而不是500个单元格.我想知道我输入错误的多个范围中的哪一个，以及 简短的，非重复的 方法.

After pressing Enter a column appears with my data, but somehow there are 480 cells instead of the 500. I want to know which of the multiple ranges I made a mistake in, as well as a short, non-repetitive way of doing this.

推荐答案

一个替代方案是:

=ARRAYFORMULA(TRANSPOSE(SPLIT(JOIN(" ", 
 TRANSPOSE(QUERY(TRANSPOSE(A1:T25), , 10000))), " ")))

或该行:

=ARRAYFORMULA(SPLIT(JOIN(" ", 
 TRANSPOSE(QUERY(TRANSPOSE(A1:T25), , 10000))), " "))

或逐列:

=ARRAYFORMULA(TRANSPOSE(SPLIT(JOIN(" ", 
 QUERY(A1:T25, , 10000)), " ")))

或该行中的逐列:

=ARRAYFORMULA(SPLIT(JOIN(" ", 
 QUERY(A1:T25, , 10000)), " "))

这篇关于如何在Google表格中将矩形的单元格转换为一行的行/列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！