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.


--
naiku
------------------------------------------------------------------------
naiku's Profile: http://www.excelforum.com/member.php...o&userid=34804
View this thread: http://www.excelforum.com/showthread...hreadid=545569