Convert table or file layout (normalized into non-normalized)

[Braka]

Does anybody has sample code that can convert Table1 into
Table2.

ID,Code,Skill = Table1
1,3267,Machine Operator
2,3267,Warehouse Worker
3,3268,Janitor
4,3269,Assembly
5,3269,Construction Eng.
6,3269,General Labor
7,7269,Janitor
8,3269,Forklift: Gas
9,3269,Machine Operator
10,3269,Production
11,3269,Warehouse

Table2
Code,Skill1,Skill2,Skill3,Skill4,Skill5,Skill6,Skill7,etc
3267,Machine Operator,Warehouse Worker
3268,Janitor
3269,Assembly,Construction Eng.,General Labor
7269,Janitor
3269,Forklift: Gas,Machine Operator,Production,Warehouse

 

[Tim Ferguson]

Does anybody has sample code that can convert Table1 into
Table2.

Yes, there is something on Dev Ashish's site <http://www.mvps.org/access>


Tim F