如何根据条件转换excel中的单元格 [英] How to transpose cells in excel based on condition

问题描述

大家好，



我有一张excel表如下：

 animal1 
 ani-dog 
 ani-cat 
 ani-cow 
 ani-horse 
 animal2 
 ani-tiger 
 ani -lion 
 animal3 
 ani-elephant 
 ani-wolf 
 ani-fox 

我需要输出为：

 animal1 ani-dog ani-cat ani-cow ani-马
 animal2 ani-tiger ani-lion 
 animal3 ani-elephant ani-wolf ani-fox 

It意味着当有一组新动物时会有细胞转座。这可以通过单一配方来实现吗？



谢谢.. !!



什么我试过了：



尝试写一个有效的宏....但是需要一个公式....

解决方案

使用单一公式没有机会实现这一点，因为数据之间没有任何关系，这意味着一组动物： {ani-elephant，ani-wolf，ani- fox} 对其群组一无所知 animal3 。



您可能感兴趣 OFFSET功能 - Office支持 [ ^ ]

Hi All,

I have an excel sheet like following:

animal1
ani-dog
ani-cat
ani-cow
ani-horse
animal2
ani-tiger
ani-lion
animal3
ani-elephant
ani-wolf
ani-fox

I need output as :

animal1	ani-dog	ani-cat	ani-cow	ani-horse
animal2	ani-tiger	ani-lion		
animal3	ani-elephant	ani-wolf	ani-fox

It means there will be transpose of cells when there is a new set of animals. Can this be achieved with single formula?

Thank you..!!

What I have tried:

Tried writing a macro which worked....but need a formula....

解决方案

There's no chance to achieve that using single formula, because there's no relationship between data, which means that set of animals: {ani-elephant, ani-wolf, ani-fox} knows nothing about its group animal3.

You may be interested in OFFSET function - Office Support[^]

这篇关于如何根据条件转换excel中的单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！