debauch
09-17-2007, 09:15 AM
Hello,
Currently we recieve a forecast each month, and there is several tabs in it. It is not in a format that we can load into our tables, so we need to change it to be vertical rather than horizontal.
I've attached a sample of how it comes, and how we'd ideally like to see it.
I've tried to do it through formula's but I cannot seem to come up with something that can will include the date.
Can someone please check out my sample attachment and share some insight on how this might be achieved?
Currently we recieve a forecast each month, and there is several tabs in it. It is not in a format that we can load into our tables, so we need to change it to be vertical rather than horizontal.
I've attached a sample of how it comes, and how we'd ideally like to see it.
I've tried to do it through formula's but I cannot seem to come up with something that can will include the date.
Can someone please check out my sample attachment and share some insight on how this might be achieved?