Excel 2007 : Combining data from different columns

[Tino XXL]

Hi all,

In attachment you'll find the data I have at hand in sheet1 marked red. I need to write a script which copies everything into sheet2 and the data should then look like the one marked in green.

Can anyone pls help me out with this one?

regards
Tino XXL

[AppSupportKarl]

are you simply trying to remove the blank cells?

[Tino XXL]

Hi,

As you can see the info in column a should be matched to B and C.

Meaning that B should show the same number until it changes and the same for C;

regards,
Tino

[watersev]

see attachement, it works fine except this row:
7573167
may be I do not see the full logic for it.