Thread: Tidy up data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Al Mackay Al Mackay is offline
external usenet poster
 
Posts: 20
Default Tidy up data

I've been given a spreadsheet which I have to tidy up each day, which
hopefully with your help this could be automated??

Each line is made up like the following:
A B C
Row (Odd Number) Always "object:" Data 1
Row (Even Number) Unique Number * Data 2

What I want to be able to do is combine the data together from row 2
within row 1, e.g.

Data from even number rows will be added on from column D onwards
Is this possible through VBA?

Many thanks for your help with this, Al.

)