How to transpose a table?

  • Thread starter Thread starter Nguyen Van Hoa
  • Start date Start date
N

Nguyen Van Hoa

I have a table with fields: Year, Sales, Cost of Good Sold and Profit. The
table records financial data year by year.
Now I want to make a report or a query that has column showing years and
three rows showing the financial data.
It means that I have transpose my current table. Supposed that I will
increase additional fields such as Tax, number of Employees etc.
Do you know how to do this?
Thank you very much
 
Back
Top