How to Make a Query that Fills Multiple Fields Based on a Tag Field

[Inaccessable]

How would I create a query that fills multiple fields in a new table based on data delimited by the value "id" in the name field. Also, not every field of every record will be filled and the number of records delimited by the id tag in the name field will vary.

An example of the conversion of the first two sets would be like so:

From:

field	name
2-AB6	id
2-AB6	prtnmbr
2910	mannmbr
87295129104	upcnmbr
2.95	listprc
1.0000	itmweight
2013-03-30T01:49:22Z	updatedate
NGK SPARK PLUG 2910/10	name
SPARK PLUG 2910/10	iname
NGK	vname
2-DP7EA9.jpg	mainimg
http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	productvideo
ATVAT0380	tabid
ATV47121	grpid
OFFOFF430	tabid
OFF47121	grpid
SNOSNO190	tabid
SNO47121	grpid
STRSTR390	tabid
STR47121	grpid
TWNTWN390	tabid
TWN47121	grpid
WTRWTR140	tabid
WTR47121	grpid
2-AB7	id
2-AB7	prtnmbr
3010	mannmbr
87295130100	upcnmbr
2.95	listprc
1.0000	itmweight
2013-03-01T01:52:03Z	updatedate
NGK SPARK PLUG 3010/10	name
SPARK PLUG 3010/10	iname
NGK	vname
2-DP7EA9.jpg	mainimg
http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	productvideo
ATVAT0380	tabid
ATV47121	grpid
OFFOFF430	tabid
OFF47121	grpid
SNOSNO190	tabid
SNO47121	grpid
STRSTR390	tabid
STR47121	grpid
TWNTWN390	tabid
TWN47121	grpid
WTRWTR140	tabid
WTR47121	grpid
2-AB8	id
2-AB8	prtnmbr
7909	mannmbr
87295179093	upcnmbr
5.95	listprc
1.0000	itmweight
2013-06-29T02:02:12Z	updatedate
NGK SPARK PLUG 7909/10	name
SPARK PLUG 7909/10	iname
NGK	vname
2-DP7EA9.jpg	mainimg
http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	productvideo
ATVAT0380	tabid
ATV47121	grpid
OFFOFF430	tabid
OFF47121	grpid
SNOSNO190	tabid
SNO47121	grpid
STRSTR390	tabid
STR47121	grpid
TWNTWN390	tabid
TWN47121	grpid
WTRWTR140	tabid
WTR47121	grpid
2-A8	id
2-A8	prtnmbr
2-AB8	superprtnmbr
1210	mannmbr
087295012109	upcnmbr
5.95	listprc
.2420	itmweight
2013-06-17T02:34:34Z	updatedate
S/S 2-AB8 NGK SPARK PLUG 1210/10	name
S/S 2-AB8 NGK SPARK PLUG 1210/10	iname
NGK	vname
2-DP7EA9.jpg	mainimg
http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	productvideo
2-BCPR5ES	id
2-BCPR5ES	prtnmbr
6130	mannmbr
87295161302	upcnmbr
2.95	listprc
.2380	itmweight
2011-11-03T11:41:00Z	updatedate
NGK SPARK PLUG 6130/04	name
SPARK PLUG 6130/04	iname
NGK	vname
2-DP7EA9.jpg	mainimg
http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	productvideo
ATVAT0380	tabid
ATV47121	grpid
OFFOFF430	tabid
OFF47121	grpid
SNOSNO190	tabid
SNO47121	grpid
STRSTR390	tabid
STR47121	grpid
TWNTWN390	tabid
TWN47121	grpid
WTRWTR140	tabid
WTR47121	grpid

To:

id	prtnmbr	mannmbr	upcnmbr	listprc	itmweight	updatedate	name_	iname	vname	mainimg	productvideo	tabid	grpid
2-AB6	2-AB6	2910	87295129104	2.95	1.0000	2013-03-30T01:49:22Z	NGK SPARK PLUG 2910/10	SPARK PLUG 2910/10	NGK	2-DP7EA9.jpg	http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	ATVAT0380…WTRWTR140	ATV47121...WTR47121
2-AB7	2-AB7	3010	87295130100	2.95	1.0000	2013-03-01T01:52:03Z	NGK SPARK PLUG 3010/10	SPARK PLUG 3010/10	NGK	2-DP7EA9.jpg	http://www.youtube.com/embed/wFkCVNhXMF0?rel=0	ATVAT0380...WTRWTR140	ATV47121…WTR47121

[June7]

This is already marked solved. I am guessing you discovered CROSSTAB query, however, that would required more than the two fields you show.