过滤每个类别的行并重新出现！ [英] Filter rows on each category and reappear!
问题描述
我有很多行（大约3000个），有一些列。他们每个都在一排，只填充第一个（A）列。
见下文
A类
1983 15648 156156 416 151 021 987464
156156 416 151 021 987464 151 021
9874 64198 378 15648 156156 416 151
类别B
115648 156156 151 021 987464 151
416 151 021 9874645648 156156 416
....等等。
我希望能够点击每个类别的一行，并自动过滤到下面的
类别A
1983 15648 156156 416 151 021 987464
类别B
416 151 021 9874645648 156156 416
再次点击每一行，应显示完整类别。可行？我尝试了复选框，但无法成功
I have many rows (around 3000) with some columns. Each of them are under a row with only the first (A) column filled.
See below
Category A
1983 15648 156156 416 151 021 987464
156156 416 151 021 987464 151 021
9874 64198 378 15648 156156 416 151
Category B
115648 156156 151 021 987464 151
416 151 021 9874645648 156156 416
....and so on.
I want to be able to click on a row on each category, and automatically filter to the below
Category A
1983 15648 156156 416 151 021 987464
Category B
416 151 021 9874645648 156156 416
By clicking again on each line the Full category should appear. Doable? I tried with checkboxes but couldn''t make it
推荐答案
你不能解释你想要什么。一个例子可以帮助添加一个解释，但它不应该被用来代替这样的一个。
我假设你只想显示一个数据行与每个类别标签，但您没有指出该行应该是什么。显然它并不像下面的第一行那么简单，但它告诉我们很少。
这是一个关于Excel或Access的问题，因为我应该解释位置逻辑使得在RDBMS（Access）中没有任何意义，即使它在电子表格（Excel）中也是如此。
You don''t explain what you want. An example can be helpful to add to an explanation, but it shouldn''t ever be used in place of one like this.
I assume you would like to show only one data row with each category label, but you give no indication of which that row should be. Clearly it''s not as simple as just the first row following, but that tells us little.
Is this a question about Excel or Access, as I should explain that positional logic makes no sense within an RDBMS (Access) even if it does in a spreadsheet (Excel).
你好NeoPa，
如你所说我想展示带有类别标签的行，以及我单击的行。见下文：
A类
1983 15648 156156 416 151 021 987464
B类
115648 156156 151 021 987464 151
416 151 021 9874645648 156156 416
如您所见，B类以下的所有单元格都与它们在一起。当我单击一行B类时，它会显示如下：
类别A
1983 15648 156156 416 151 021 987464
类别B
416 151 021 9874645648 156156 416
Hi NeoPa,
as you said I would like to show the row with the category label, and the row I clicked on. See below:
Category A
1983 15648 156156 416 151 021 987464
Category B
115648 156156 151 021 987464 151
416 151 021 9874645648 156156 416
As you can see all the cells below category B would be as they where. When I click a row of category B then it would show the below:
Category A
1983 15648 156156 416 151 021 987464
Category B
416 151 021 9874645648 156156 416
NeoPa：
这是一个关于Excel或Access的问题，因为我应该解释一下，即使在电子表格（Excel）中，位置逻辑在RDBMS（Access）中也没有意义。
NeoPa:
Is this a question about Excel or Access, as I should explain that positional logic makes no sense within an RDBMS (Access) even if it does in a spreadsheet (Excel).
我认为这是一个Excel问题，从你到目前为止所说的，但我确实特别提出了问题，所以我觉得这是相当的在我花费更多时间之前，我有理由期待答案。
如果我开始解释一个应用程序，当你实际在另一个应用程序工作时，那么我就是只是浪费了我不必要的时间。
I would assume this is an Excel question from what you''ve said so far, but I did ask the question specifically, so I feel it''s quite reasonable to expect an answer before I spend any more time on this.
If I start to explain for one application when you''re actually working in the other, then I''m just wasting more of my time unnecessarily.
这篇关于过滤每个类别的行并重新出现！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
