Hi - I am very sorry to mention but extracting the data from Omniture is a horrible experience. I have been using some Oracle based system for extracting data and Oracle allows you to extract data in a pivot format, means you can quickly create pivot and amend the data as per your requirements.
For Example: If I extract the data from discover with segments, Omniture data is of no usage unless I change it to pivot format. This is something you guys need to address as urgency as pivot is a GOD for analyst.
Thanks
Vijesh