The problem with cross tab or pivot method is that we have to hard-code total number of columns.

Here in the table t2 there may be any number of rows for...