Access to arrange the data from vertical to horizontal

[dhen21dx]

Hello,

I need advise on how can i do the sets of data from vertical to horizontal. here is the example below.

ID	Catergory	Descr
11111​	Sales ID	UUAD
11111​	Origin	US
11111​	PurVar	5​
11111​	Decr	Delta
22222​	Origin	TH
22222​	PurVar	7​
33333​	Sales ID	UUAT
33333​	Origin	DE
33333​	Decr	Delta_XR

Result:

ID	Sales ID	PurVar	Origin	Decr
11111​	UUAD	5​	US	Delta
22222​		7​	TH
33333​	UUAT		DE	Delta_XR

 

[dhen21dx]

Result may not always having all the heading and i want to have all headings to be concrete, or will it be possible that we can get the value of Descr if criteria is ID and "Sales ID", ID and "Origin" etc...

 

[petertenthije]

Can you show the source data as they are listed in Access? My guess is that your Access source data and the data in your first post no longer match.

 

[dhen21dx]

Hi Peter,

The source data is the first set of data and that is the result of several queries updated into one table. Then next thing to do is to make it like a template(horizontal) in the second set of my sample, the header should be fixed value and that i need to put the value on the columns.

 

[Micron]

Me neither. Must be something wrong about my table records. In that case the OP has a solution.

 

[dhen21dx]

I got the solution now, i use the transform and have created query to append to my created table with predefined headings. Thank you.