Transpose data from rows to columns

[Eddy]

Hi,

I've been checking (and trying) different answers given on the transpose
subject but no avail.

I've received a source file with data in rows like:

EmployeeNumber Field1
1 A
1 B
2 A
3 A
3 B
3 C

I need to manipulate the data to end up with following target table structure

EmployeeNumber Field1 Field2 Fieldd3
1 A B
2 A
3 A B C

Any suggestions will be much appreciated

Thanks

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Denormalize.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Eddy]

Roger,

Thanks for your prompt reply. The code does what I need to do and I'll will
try on my real data.

Please note that the module "denormalize" (denormalize2k.zip) refers to
Table3 in error. It should read "Set rs1 = db.OpenRecordset("Table1") 'table
with old format"


Thanks

Cheers