SQL Scripts Needed

[Tayewo]

please I need to write a select statement to to get a report format in table 2

I have a table below (Table 1) in my database and need to generate a report in the Table 2 format

Table 1

MeasureName Location Period BudgetActual Data
Novels ***** 2007/03 Actual 2,536
Novels ***** 2007/03 Budget 25,897
Medical Books ***** 2007/03 Actual 1,478
Medical Books ***** 2007/03 Budget 2,589
Science Books ***** 2007/03 Actual 4,887
Science Books ***** 2007/03 Budget 369
Sociology Books ***** 2007/03 Actual 1,578
Sociology Books ***** 2007/03 Budget 35,897
Liberal Arts Books ***** 2007/03 Actual 2,564
Liberal Arts Books ***** 2007/03 Budget 25,687

Table 2

MeasureName Location Period Actual Budget
Novels ***** 2007/03 2,536 25,897
Medical Books ***** 2007/03 1,478 2,589
Science Books ***** 2007/03 4,887 369
Sociology Books ***** 2007/03 1,578 35,897
Liberal Arts Books ***** 2007/03 2,564 25,687

Can somebody help out please?

[kaffenils]

And we are so good at guessing what DBMS you are using....

[stanleyomeike]

Oracle Database I guess