Excel将行转换为具有组的列 [英] Excel Converting rows to columns with groups

问题描述

假设我在excel中设置了这样的列:

Let's say that I have my columns in excel set up like this:

Name     A    B    C    D  
George   10   5    4    6

我希望它像这样:

Name   Category   Amount  
George     A        10  
George     B         5  
George     C         4  
George     D         6

是否有一种简单的方法可以通过转置或数据透视表进行复制和粘贴，还是必须使用VBA进行复制和粘贴?我一直试图仅使用VBA来做到这一点，但我还没有走得很远.

Is there an easy way to do a copy and paste with transpose, or with a pivot table, or does it have to be done with VBA? I've been trying to only do it with VBA but I havent gotten very far.

推荐答案

根据评论，您可以点击该链接.描述了Excel 2010相似步骤的相关SO答案为

As per comment, you can follow that link. A related SO answer that describes similar steps for Excel 2010 is How can I transform rows into repeated column based data?.

这篇关于Excel将行转换为具有组的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！