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 a given name.

How do I handle that?