I down load from SAP to Excel quite often. There is one facet I use and I
ALWAYS have a ton of blank cells. I need to remove them but keep a structure
to the data. Here is a rough idea of what I am working with...... Mind you
this there is this type of info througout the spreadsheet. So if I delete
cells and it asks to shift up or left.. it brings all the data together. ANY
IDEAS?????

10000XXXX Joe Schmoe

10000XXXY Joe Schmoe

1234567 The Store

1234568 The Store

1234569 The Store

1234510 The Store

1234511 The Store

1234513 The Store

1234514 The Store

1234515 The Store

1234516 The Store

1234517 The Store

1234518 The Store