So i have this data set:

	NoDur	Durbl	Manuf	HiTec	Telcm	Shops	Hlth	Utils	Other
NoDur	1
Durbl	0.536846057	1
Manuf	0.644146214	0.848498687	1
HiTec	0.600063067	0.713087978	0.791508393	1
Telcm	0.72574302	0.615540529	0.686835289	0.564694	1
Shops	0.661277938	0.677376389	0.760094061	0.757218	0.649069	1
Hlth	0.536914101	0.666009499	0.742874083	0.628285	0.554179	0.730191	1
Utils	0.505378397	0.182101034	0.277432996	0.279409	0.331027	0.305537	0.27251	1
Other	0.559265822	0.865647377	0.884469181	0.742266	0.671048	0.767933	0.689753	0.139395	1

I am required to finish the blank columns with the corresponding values using the "Paste Special Transpose Command". Does anyone know how to finish this matrix? I used the correlation function in the data analysis box but it did not complete it.