Transpose Similar Rows to Same Columns

[beetle_cca]

Hi,

Very new to excel and have the following dilema.

Have a sheet (Data) as per below. What I would like to do is have a Summary sheet with headings <Day><Time><Who><Title><Title Short> that automatically updates when the data sheet updates. Any changes to the data spreadsheet will be adding information into the next column.

Any suggestions on the easiest way to accomplish this would be greatly appreciated. TIA.

<DATA>[TABLE="width: 500"]
<tbody>[TR]
[TD]Day[/TD]
[TD]Mon[/TD]
[TD]Mon[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Tues[/TD]
[TD]Wed[/TD]
[/TR]
[TR]
[TD]Time[/TD]
[TD]07:30[/TD]
[TD]07:45[/TD]
[TD]07:50[/TD]
[TD]07:30[/TD]
[TD]08:00[/TD]
[TD]08:00[/TD]
[/TR]
[TR]
[TD]Who[/TD]
[TD]Emp1[/TD]
[TD]Emp2[/TD]
[TD]Emp3[/TD]
[TD]Emp1[/TD]
[TD]Emp1[/TD]
[TD]Emp2[/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD]Queue Assist[/TD]
[TD]Queue Assist[/TD]
[TD]Queue Assist[/TD]
[TD]Queue Assist[/TD]
[TD]Queue Assist[/TD]
[TD]Queue Assist[/TD]
[/TR]
[TR]
[TD]Title Short[/TD]
[TD]QA[/TD]
[TD]QA[/TD]
[TD]QA[/TD]
[TD]QA[/TD]
[TD]QA[/TD]
[TD]QA[/TD]
[/TR]
[TR]
[TD]Day[/TD]
[TD]Mon[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Tues[/TD]
[TD]Wed[/TD]
[TD]Wed[/TD]
[/TR]
[TR]
[TD]Time[/TD]
[TD]07:45[/TD]
[TD]07:30[/TD]
[TD]07:50[/TD]
[TD]08:00[/TD]
[TD]08:30[/TD]
[TD]08:45[/TD]
[/TR]
[TR]
[TD]Who[/TD]
[TD]Emp1[/TD]
[TD]Emp2[/TD]
[TD]Emp2[/TD]
[TD]Emp2[/TD]
[TD]Emp3[/TD]
[TD]Emp3[/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD]Callback[/TD]
[TD]Callback[/TD]
[TD]Callback[/TD]
[TD]Callback[/TD]
[TD]Callback[/TD]
[TD]Callback[/TD]
[/TR]
[TR]
[TD]Title Short[/TD]
[TD]CB[/TD]
[TD]CB[/TD]
[TD]CB[/TD]
[TD]CB[/TD]
[TD]CB[/TD]
[TD]CB[/TD]
[/TR]
</tbody>[/TABLE]

 

[beetle_cca]

ADDED IN ERROR