Excel组合多行 [英] Excel Combining Multiple Rows
问题描述
我觉得我错过了一些简单的我想用Excel做的事情,但是我在Google上提出错误的问题...这里是。
I feel like I am missing something simple I would like to do with Excel but I am asking the question incorrectly on Google...here it goes.
我看一下运行竞赛计时公司的朋友的Excel表格。在比赛结束时,他有一个excel表格,具有以下格式进行一系列比赛。
I'm taking a look at some Excel sheets for a friend who runs a race timing company. At the end of a race he has an excel sheet with the following format for a series of races
名称|性别|年龄|第1场|第2场|比赛3
Bob |    M | 20 |      1      |             |
Al |    M | 24 |      2 |             |
Bob |    M | 20 |              |      2 |
Al |    M | 24 |              |      1 |
Name | Gender | Age | Race 1 | Race 2 | Race 3
Bob | M | 20 | 1 | |
Al | M | 24 | 2 | |
Bob | M | 20 | | 2 |
Al | M | 24 | | 1 |
::假设我们现在不关心时间,只需放置::
::Assume we don't care about time right now, just place::
我想做某事(再次,我不知道什么是正确的术语,在Excel中合并实际上将两个邻接单元合并在一起),在那里我可以得到最终的输出,使得
I would like to do "something" (again I'm not sure what the proper term is, merge in Excel actually merges two adjecent cells together), where I can get the final output such that
名称|性别|年龄|第1场|第2场|比赛3
Bob | M |   20 |      1 |      2 |
Al | M |   24 |       2      |      1 |
Name | Gender | Age | Race 1 | Race 2 | Race 3
Bob | M | 20 | 1 | 2 |
Al | M | 24 | 2 | 1 |
我不知道如何将类似行的数据合并在一起。
I'm not sure how to collapse the data for the like rows together.
我不反对写一个VBA,但我认为这是一个内置的Excel函数,但我不知道它被称为什么或如何让它跳舞。
I'm not opposed to writing a little VBA, but I am thinking this is a built in Excel function but I'm not sure what it is called or how to make it "dance".
谢谢!
推荐答案
这篇关于Excel组合多行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!