Column/sub-column headers

[Guest]

ExtID Peak 2theta dSp FWHM B PtSize
Sample1 Cao 20 40 60 80 100
Sample1 MgO 50 80 40 100 60
Sample2 Al2O3 13 25 47 89 51
Sample2 Cao 13 25 47 89 51

I would like to see the data as
Cao MgO Al2O3
ExtID 2theta dSp FWHM B PtSize 2theta dSp B....
Sample1 20 40 60 80 100 50 80 40
Sample2 13 25 47 89 51 13

Basically the ExtID as the Rows, Peak as ColumnHeader and the other fields
as Sub-Column Headers

Any ideas on how I can accomplish this? Thanks for the assistance.

 

[[MVP] S.Clark]

Group it in a report, or write the data to a temp table as desired using
action queries.