Thanks for responses, here is the answers to questions.

Jeff -  Destination is unknown, we just need to place file in network location in specific format requested by destination team

Phil -...

Thanks Thom, I have thought of LAG function to use, it will work for sure. the only worry is need use same function 200 times as 200 columns in a...

It does look good, it worked almost 98%, but issue is here with order, the few columns are added to table later - I mean not with original table creation,...

You got it Thom, That's correct, Am looking for dynamic, my table contains more than 100 columns and also 90-92 rows for Each ID -  EX: table contains 3months data...

Good Catch 🙂 I have updated code now, Yes i need cross tab query. Please let me know if any questions.

I can use cast/convert to change data type of column while doing pivot/unpivot. Can above solution is feasible?

I see it, i have added extra number in first line, which is incorrect. Below is the corrected output.

one ID can have multiple rows

224A ‘1/1/2012’ ‘2/1/2012’
224A 1000...

We can convert to float, it will take care.

Select TRY_CONVERT(FLOAT,[Call Length]) FROM AAAJFJunk

Correct Jeff, I don't want to export to excel due to CSV is much faster than Excel exporting. It's not one file to open and format data in...