wanox (7/26/2013)
I cannot pivot in excel (source data).I have tried to pivot as part of my data flow and have not been successful. Can you help me out here please
The data in the table looks like this:
ID Date Value
10 getdate() 1.357
The ID is generated by running a query to select name from another table where name matches the column name on the spreadsheet.
Can you post a few more lines of sample data and the desired output?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP