So both @revels and I have indeed had a go at this before.
Take a look at this thread:
It does mean that the data for one transaction is split along columns, so basically any further analysis of your data needs to look into all the columns where data is.