转置和粘贴像A1和&对于许多列，A2必须是B1和C1 [英] Transpose and Paste Like A1 & A2 has to be B1 &C1 For many columns

问题描述

亲爱的所有

我有大约250列，每列包含250个数字，我想以下面的方式转置和粘贴

Dear All
I have Around 250 columns each columns contains 250 Numeric digits, I want to Transpose and Paste in a Manner like Below

Column A                 Column B                  Column C

2                           2                         3                  
3                           2                         5     
2                           4                         0    5                                                                                  4                           
0                           9                         1
9
1                           3                         7                      
3
7                           6
6

请有任何人帮我，我是一个农村学生，在我的办公室，这项工作是给我的，我必须做250个专栏，这需要花费太多时间。列A数据必须在B和C列中进行转置和粘贴，如下所示。

Please Any body help me I am a rural student, In my office this work is given to me i have to do this for 250 columns this take too much time. Column A data has to be transpose and paste in Column B and C, like this.

推荐答案

您已经知道了操作的名称，您只需拥有现在使用谷歌。

我不确定'transpose'是否正确。

您的示例显示列A中的内容在列中重写B和C但行不规则。

是否有理由将3个第一行分组而不是其他行？

You already know the name of the operations, you just have use google now.
I am not sure that 'transpose' is the right word.
Your example show that what is in column A is rewritten in columns B and C but rows are not regular.
Is there a reason to have the 3 first rows grouped and not the others ?

这篇关于转置和粘贴像A1和&对于许多列，A2必须是B1和C1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！