|
Copy Data on Row Change
I have large list of business addresses (see below). There are
multiple rows for each company (varies). I would like to sort down the list by company name (column 1) and for each new company i would like to copy the line and paste it in a different worksheet (so that i will have a list with one row for each company). Current Data: ZIPSORT INC 100042011 1820 WRIGHT ST ZIPSORT INC 100044694 4950 S 6TH ST ZIPSORT INC 100044694 4950 S 6TH ST ZIPSORT INC 100044694 4950 S 6TH ST ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZANDER PRESS INC 49060600 425 W RYAN ST ZANDER PRESS INC 49060600 425 W RYAN ST ZANDER PRESS INC 49060600 425 W RYAN ST XL MARKETING GROUP INC 10004165 845 BONNIE LN XL MARKETING GROUP INC 10004165 845 BONNIE LN XL MARKETING GROUP INC 10004165 845 BONNIE LN Goal: ZIPSORT INC 100042011 1820 WRIGHT ST ZIP MAIL SERVICES 10008799 4350 UNITED PKWY ZANDER PRESS INC 49060600 425 W RYAN ST XL MARKETING GROUP INC 10004165 845 BONNIE LN What are some basic functions to do this? |
| All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com