ampatel007
asked on
Side-by-Side Transformation of Table Data
I have data that looks like the below. Note: the number of columns will vary and the number of rows will vary as well so the solution has to be dynamic and acount for that.
Co-Pay | Deductible | Co-Insurance
Plan A 10 55 140
Plan B 20 75 360
Plan C 30 95 779
and need the data to be transposed (NO AGGREGATION FUNCTIONS)
to look like this
Plan A | Plan B | Plan C
Co-Pay 10 20 30
Deductible 55 75 95
Co-Insurance 140 360 779
Co-Pay | Deductible | Co-Insurance
Plan A 10 55 140
Plan B 20 75 360
Plan C 30 95 779
and need the data to be transposed (NO AGGREGATION FUNCTIONS)
to look like this
Plan A | Plan B | Plan C
Co-Pay 10 20 30
Deductible 55 75 95
Co-Insurance 140 360 779
You mean you just want to display the table on its side? Do that in your presentation or reporting tier. If you think you need to do it in the database for some reason then it might help to know what you are trying to achieve.
ASKER
I need to perform this in the database itself for performance reasons as the datasets in some cases will be very large and transmitting data to middle-tier will be expensive. Trying to achieve side-by-side reports like (Consumer Reports).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.