创建一个新列表，并从现有列表中删除空单元格 [英] Creating a new list and eliminate empty cells from existing list

问题描述

我有以下Excel电子表格：

I have the following Excel spreadsheet:

         A           B            C           D
1    Product A      500       Product A      500
2    Product B      300       Product B      300
3    Product C      400       Product C      400
4                             Product D      600
5                             Product E      550
6    Product D      600       Product F      200
7    Product E      550       Product G      800
8
9    Product F      200
10   Product G      800

在列A 和列B 中列出了销售的不同产品。
如您所见，可能会发生列表之间有空单元格。

In Column A and Column B different Products with their sales are listed. As you can see it can happen that there are empty cells in between the list.

在列C 和列D 我想实现，现在，空单元格被删除，产品列表显示没有空单元格。

In Column C and Column D I want to achieve now that the empty cells are deleted and the list of the product is shown without the empty cells.

你知道一个公式这可以做到这一点？

Do you know a formula which can do this?

推荐答案

在C1中，复制一个列，两者都适合：

In C1, copy across one column and both down to suit:

=INDEX(A:A,SMALL(IF(ISBLANK(A:A),"",ROW(A:A)-MIN(ROW(A:A))+1),ROW(A1)))

（输入CSE）...那么请耐心等待

(entered CSE) ... then be patient.

这篇关于创建一个新列表，并从现有列表中删除空单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！