How to Transpose Need some help, hint would be fine

[gopal5879]

Have Transaction coming in the form below :

Transaction Data Model
WorkItem	Status
1	AssignedForWork
1	Work Complete
2	UnAssigned
2	Sent to QA
2	Work Complete
3	Required Rework
3	AssignedForWork
3	Outreach No
3	Work Complete

How can I transpose the data to look like in script  or what is the best way If not one of the charts require data as in below format, Attached is PNG file

[jwjackso]

Check the Crosstable statement

[Shubham_Deshmukh]

Just elaborate more, it is easy I think. Yiu just want statuses in horizontal rows or what ?