Lookup and Move Data Function Help

[naiku]

Hi all, I am new here and already I need some help in creating a formula
for Excel XP, I am sure I have seen something like this before, but
cannot figure it out, and so am hoping someone here can help me.

I have downloaded some data from SAP and want to move everything into
columns A and B, the download from SAP is a bit like a tree (think
Windows Explorer) and so currently in Excel I have a lot of blanks. For
example in row 1 I currently have cell B1 populated, and cell F1
populated, I want to move this information to cell A1 and B1. In row 2
I could have cell D2 and cell K2 populated, again I want these moved to
cells A2 and B2.

If it makes it easier I can insert 2 new columns A and B so that any
data is being moved to an empty column (I figure this is easier than
facing the possibility of moving something from B to A and then
something on the same row from D to B).

I have an idea of how I want this to work, just don't know how to put
it into a working formula. At the moment I think I need to create a
look up which will move across the row inspecting each cell, if the
cell is null, it moves onto the next cell, when it finds a cell with
data in it then moves that data to column A, it then loops as does the
same thing but moves any data it finds on the second pass into column B
(there is no more than 2 levels of data).

So is this possible? can anyone help?? Thanks.

 

[Guest]

Think I understand what you're looking for, try this:

1) Select your range
2)<Edit><Go To...>
3) Select "Special"
4) Select "Blanks"
5) <Edit><Delete...>
6) Select "Entire row"

Does that help?

 

[Guest]

Hello,

Sorry but if you chose Item 6) of the David suggestion ENTIRE ROW, you will
lost every data, chose dislocate to left or something like this

Regards from Brazil 6th Soccer word championship
Marcelo

"David Billigmeier" escreveu:

 

[Pete_UK]

You could do this with a macro which starts in cell A1 and if the cell
is empty then the cell is deleted so that B1 and F1 become A1 and E1.
If the cell is not empty then move to B1 and apply the same comparison
and deletion of empty cells until the cell is not empty. Then drop down
to row 2 column A and repeat the process.

Hope this helps.

Pete