I would create 3 €˜Helpercolumns.
From the data youve supplied, it looks like your data comes over in 6
columns, A thru F.
- Insert 3 columns to the left of the data so that columns A, B and C are
blank.
- In Column A, put the formula =ROW()
This will keep track of the order that your rows are currently in
- In column B, put the formula =CONCATENATE(D1,E1,F1)
Assuming that you are starting in row 1
- In column C, put the formula =CONCATENATE(G1,H1,I1)
Assuming that you are starting in row 1

Columns B and C will combine the blank cells with the cells that have data
in them.

Copy these 3 formulas down to the end of your data.

- Using the Paste Special function, make these formulas into values.
- Sort on Column B. This will put all blank rows at the top.
- Delete the blank rows.
- Re-sort on Column A. This will put the data back into it's original order.
-Delete Columns D thru I. This deletes the original data with it's many
blank cells that you don't want.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"DestinySky" wrote:

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