Converting row based data to column based

Question

I'm sure there's a different way to name this, and I'm sure I'm making this more difficult that it needs to be. I have data in the following format:

TestScriptNameA, passedTestPoints, FailedTestPoints, ExecutionDate

TestScriptNameB, passedTestPoints, FailedTestPoints, ExecutionDate

....

...

You get the idea. I would like to turn this into the following:

TestScriptNameA, ExecutionDate1, passedTestPoints1, failedTestPoints1, ExecutionDate2, passedTestPoints2, failedTestPoints2, .....

TestScriptNameB, ExecutionDate1, passedTestPoints1, failedTestPoints1, ExecutionDate2, passedTestPoints2, failedTestPoints2, .....

and so on and do forth.

I tried with a PivotTable, and I'm sure I'm doing something wrong, but it's not working out the way I'd like.

Any help would be appreciated.

azure_sqldba · Answer

Delimit them with comma (,) and copy the data than paste special with Transpose option. This should work

Forum Discussion