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.
)
|