Is it any easy way to create a "pivot"ed table of data to compare result data in several columns, but without actually summing/counting or doing other pivot operations?

example:

arrange the following

A B C D E 1 10 101 201 X 1 20 102 202 Y 2 10 103 203 Z 2 20 104 204 Q like so A C' C'' D' D'' E' E'' 1 101 102 201 202 X Y 2 103 104 203 204 Z Q

where the value of B determines which column to show the data from C or D in.

(hoping the example will make the question possible to understand)

I can think of doing lookups with concatenated values of A and B, or creating the data in several steps, but it would be rather cumbersome. Are there any shortcuts to get this functionality in Excel?