Pivot-table versus crosstab queries

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

I have data in an Excel spreadsheet. The spreadsheet
contains several tabs. Each tab is named after a Region,
and contains a list of applications that pertain to that
region.

I have been doing the following:
1. importing these tabs into an Access table,
2. adding a coumn called Region,
3. populating this column according to the name of the
tab it was taken from,
4. running a crosstab on the data using Region as
Columnheading and finally
5. exporting the resultset of the crosstab query back to
Excel

Can a crosstab query's results be achieved using features
native to Excel such as pivot tables?

Can someone suggest a more efficient way of doing the
above?

Thanks!

Regards,
Rajat
 
Back
Top