I would like to transpose the data in sheet 1 to the format in sheet 2 for approximately 300 unique customers.


Sheet 1
Current Cust Layout

COL A---COL B-------------COL C-------COL D------COL E
CustA---101 anywhere-----anytown-----Ontario-----H4X 2E7
CustB---102 somewhere---dullsville-----BC---------V0G 1E5
etc


Sheet 2
Web Layout

COL A
CustA
101 anywhere
anytown, Ontario H4X 2E7

CustB
102 anywhere
dullsville, BC V0G 1ES