Convert Columns to Rows
hi,
you wont have to reformat.
the import/export driver will do that. and i am pretty
sure that oracle has the driver for excel built it.
-----Original Message-----
I have a very large spreadsheet. The first 2 columns are
a description, and
the next 52 columns are a value for a week of the year.
Is there a way in Excel to transform these into a format
that is loadable
into a relational database such as Oracle?
For example, I'd like to change the following into the
latter format. The
first column would be a derived week number. That first
column is something
I could live without if I had to.
Any suggestions for a simple macro would be appreciated.
washer sunday 33 44 55.........
dryer monday 667 333 44........
refrig monday 555 876 99.......
1 washer sunday 33
2 washer sunday 44
3 washer sunday 55
1 dryer monday 667
2 dryer monday 333
3 dryer monday 444
1 refrig monday 555
2 refrig monday 876
3 refrig monday 99
.
|