I have a spreadsheet with about 40000 rows. the combination of three rows and 4 columns is one record. The customer name is in column A Row 1, the street address is column B row 2, the city is column C Row 3, and the zip is column D row 3.I need to create a spread =sheet with Customers in Rows and Address, City, State and Zip in columns
Solved by C. H. in 22 mins