Layout of ODBC Data Import

G

gc.johnson

Hi


I have a database table that contains data in the following format: -


Category Sub-Category Error Code
CAT1 SUBCAT1 ERRCOD1
CAT1 SUBCAT2 ERRCOD2
CAT2 SUBCAT1 ERRCOD1
CAT2 SUBCAT2 ERRCOD1
CAT2 SUBCAT2 ERRCOD2


When imported into Excel I would like it to appear as follows: -


CAT1 CAT1 CAT2 CAT2
SUBCAT1 SUBCAT2 SUBCAT1 SUBCAT2
ERRCOD1 Y N Y Y
ERRCOD2 N Y N Y


Where there is a Y wherever an error code is used for
category/sub-category, and N (or blank) wherever not used.


I tried using a PivotTable to do this but failed miserably! Does
anyone have any ideas how to do this???


Thanks
Gary
 
Top