I need a Urgent reply on creating this report

[#1]

Hi everyone I'm new to qlik view. I want to develop a report with data extracted from excel which looks like

Test             T1

John             1

Mathew         2

Clark             1

Shane            2

Now I need a report which should look like

Test

John     1

Clark     1

T1

Mathew   2

Shane     2

Hope to hear back from you soon!!!!

[#2]

hope this works