需要从数据行创建列 [英] Need to create colums from rows of data
本文介绍了需要从数据行创建列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何创建此更新表或导出?我有一个包含多个重复记录的表,其中一列具有不同的值。
我想更改这些记录
EMPI | Date_of_Service | 电子代码 |
964 | 09/07/2014 | E000.8 |
964 | 09/07/2014 | E013.0 |
964 | 09/07/2014 | E849.0 |
964 | 09/07/2014 | E917.4 |
2329 | 12/06/2014 | E814.7 |
2329 | 12/06/2014 | E849.5 |
到此
EMPI | Date_of_Service | E-Code | E-Code2 | E-Code3 | E-Code4 | E-Code5 | Column1 |
964 | 09/07/2014 | E000.8 | E013.0 | E849.0 | E917.4 | | |
12/06/2014 | E814.7 | E849.5 | | | | | |
06/18/2014 | E928.9 | | | | | | |
02/01/2014 | E849.0 | E950.0 | | | | | |
02/01/2014 | E950.0 | | | | | |
解决方案
使用交叉表查询。
单击"创建","查询向导","交叉表查询向导",然后选择行,列和值。
How can I create this to update a table or in an export? I have a table with multiple duplicate records that have a single column with different values.
I want to change these record
EMPI | Date_of_Service | E-Code |
964 | 09/07/2014 | E000.8 |
964 | 09/07/2014 | E013.0 |
964 | 09/07/2014 | E849.0 |
964 | 09/07/2014 | E917.4 |
2329 | 12/06/2014 | E814.7 |
2329 | 12/06/2014 | E849.5 |
To this
EMPI | Date_of_Service | E-Code | E-Code2 | E-Code3 | E-Code4 | E-Code5 | Column1 |
964 | 09/07/2014 | E000.8 | E013.0 | E849.0 | E917.4 | ||
2329 | 12/06/2014 | E814.7 | E849.5 | ||||
3186 | 06/18/2014 | E928.9 | |||||
23942 | 02/01/2014 | E849.0 | E950.0 | ||||
23942 | 02/01/2014 | E950.0 |
解决方案
Use a Crosstab query.
Click on Create, Query Wizard, Crosstab QueryWizard and select rows, columns, and values.
这篇关于需要从数据行创建列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文