John Mount has a video explaining the concepts behind cdata:
We also have two really nifty articles on the theory and methods:
Please give it a try!
Click through for the video, which I found very helpful in tying together a number of data transformation operations (pivoting, unpivoting, one-hot encoding, etc.).