根据Google表中的单元格值将行转置为新列
如果E列中的单词说“餐饮”，我目前正在尝试进行行并将其转换为另一个表格。我似乎无法弄清楚如何使公式抓住当前的行，我想知道我是否必须编写一个应用程序脚本。我已经尝试过，如果用transpose表示陈述，则无济于事。我尝试运行查询，这也没有帮助。
要清楚，我希望该公式查看E列是否说餐饮，并在其上进行餐饮单词的行，并将其垂直转置到Sheet2中。如果可以在转移时消除空字段，那就更好了。
这是我正在与之合作的表格的示例。
I am currently trying to take a row and transpose it into another sheet if the word in column E says "catering". I can't seem to figure out how to get the formula to grab the current row and I am wondering if I am going to have to write an app script instead. I have tried and IF statement with TRANSPOSE to no avail. I have tried running a query and that hasn't helped either.
To be clear I want the formula to see if column E says catering and if it does then it takes the row with the word catering and transposes it vertically into sheet2. If empty fields could be eliminated on transfer that would be even better.
Here is an example of the sheet I am working with.
https://docs.google.com/spreadsheets/d/1C6cPwtg0CZVfhjZm3KIxGJzcQaOfWCNXMWSKOei-zx0/edit?usp=sharing
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
尝试：
try:
当您使用标准
餐饮时，您不需要使用不是null。 transpose是什么意思？尝试-While your are using criteria
Cateringthen you no need useis not null. What do you mean by transpose? Try-我正在玩提供的公式。我认为这会解决问题：
= transpose（query（Sheet1！1：996，“选择 * WHERE E ='catering'sord a a a”，0））>I'm playing around with the provided formula. I think this will do the trick:
=TRANSPOSE(QUERY(Sheet1!1:996, "Select * Where E = 'Catering' Order by A",0))