在Excel中进行特定的转置 [英] Specific Transpose in Excel

问题描述

我想做这个人想做的事情。

I would like to do the opposite of what this person wants to do.

Excel 2010中的特定转置

向后移转有效。

在stackoverflow上有一个如何做相反/反向按钮是很好的。

It would be nice to have a "how to do the opposite/reverse" button on stackoverflow.

同时，我将尝试将提供的代码作为解决问题的方式进行反转。

In the mean time I will be trying to reverse the code given as a solution to the question asked.

推荐答案

我设置了如下数据：

在列E中，我只是自动填充数字，直到我在列A中达到最高数字。然后我在指定的单元格中使用以下公式，并从那里自动填充。

In column E, I just auto-filled numbers until I reached the highest number in Column A. Then I used the following formulas in the cells indicated and auto-filled down from there.

F5：

=OFFSET($B$1,(($E5-1)*3+0),0)

G5：

=OFFSET($B$1,(($E5-1)*3+1),0)

H5：

=OFFSET($B$1,(($E5-1)*3+2),0)

* 3应该反映你拥有的类别数（这里：品牌，颜色，价格）。要添加其他列，只需继续增加每个类别列中* 3之后立即添加的数字。

The *3 should reflect the number of categories you have (here: brand, color, price). To add additional columns, just keep increasing the number that's added immediately after *3 in each category column.

我应该注意，这只有在您的数据真的就像这个例子，每个项目的连续数字标识符从1开始。

I should note, this is only going to work if your data really is just like the example, with consecutive numeric identifiers for each item starting at 1.

这篇关于在Excel中进行特定的转置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！