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
Bookmarks