Question data transform

[sandy70]

hi guys

anyone know how to transform this data

to this ??

any idea how to make it ???

 

[jdraw]

What exactly do these represent?
First looks like a spreadsheet, or a CrossTab; second looks like 4 database records.

You may get more info here
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

 

[sandy70]

What exactly do these represent?
First looks like a spreadsheet, or a CrossTab; second looks like 4 database records.

You may get more info here
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

this some data i got from my friend :

and this is what the table my friend want to make

 

[sandy70]

there is about 50 or 60 columns

 

[sandy70]

The code solution isn't that bad. Use the fields collection of the tabledef to get the column names.

can u give more detail about it ??? or may be some example

still confuse about is