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>

Day	Mon	Mon	Mon	Tues	Tues	Wed
Time	07:30	07:45	07:50	07:30	08:00	08:00
Who	Emp1	Emp2	Emp3	Emp1	Emp1	Emp2
Title	Queue Assist	Queue Assist	Queue Assist	Queue Assist	Queue Assist	Queue Assist
Title Short	QA	QA	QA	QA	QA	QA
Day	Mon	Mon	Tues	Tues	Wed	Wed
Time	07:45	07:30	07:50	08:00	08:30	08:45
Who	Emp1	Emp2	Emp2	Emp2	Emp3	Emp3
Title	Callback	Callback	Callback	Callback	Callback	Callback
Title Short	CB	CB	CB	CB	CB	CB

<tbody>
</tbody>

 

[beetle_cca]

ADDED IN ERROR