Hello All,

I have a semi large excel file with close to five thousand rows and aprx.sixteen columns. In column "A" is a listing of all my customers (a lot with the same name, but different addresses). When this file was created each row had a certain type of equipment, so one individual customer could have eight rows. You can imagine my frustration when I have to redesign this file and have one row that has their name in one column, address in another, etc. along with each type of equipment in it's own predetermined column.

Besides filtering each individual customer (aprx 2k different) and physically move the cells to the correct column, is there an easier way.

Please see the attached file for a quick visual.

Excel Example.jpg

Thank you all in advance,
Aaron