将行转置到MS Access 2007中的列。 [英] Transpose rows in to columns in MS Access 2007.

问题描述

I need to transpose rows in to columns in MS Access 2007.

Here we go, Below is the input data in Table01 which should be transposed.
      Table01
+--------------+---+
Field1   |    Field2|
----+--------------+
 Begdoc       ABC_001
 Enddoc       ABC_003
 DOCTYPE      EDOCS
 Begdoc       ABC_004
 Enddoc       ABC_008
 DOCTYPE      EMAIL
+---+----+--------------+

I want the result in below format :

           Table01
+----------+---+---------------+
Begdoc   |   Enddoc  |  DOCTYPE
----+----------------+---------+
ABC_001      ABC_003    EDOCS
ABC_004      ABC_008    EMAIL

+---+----+--------------+

How can we perform the above result in ms access ?

推荐答案

是的，有一些限制，您可以使用交叉表查询将行转换为列。

Yes, with some limitations, you can use a Crosstab query to transpose rows into columns.

试一试，让我们知道它是怎么回事。

Give it a shot and let us know how it goes.

这篇关于将行转置到MS Access 2007中的列。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！