I have a spreadsheet with several columns. I have a number in Column B with several rows of tasks and dates under that apply to that number and then another number with rows under it (often not the same number of rows as above.) And so on for 100's of lines. I want to add a column and move the number to that column or replace the job number column with the number. I want to fill the number down until the next number comes up and fill it down until the next number comes up and so on. The reason is to allow for pivots and use in other Microsoft software apps. Right now if I try to sort or do something with the data, I can't tell what goes where. I recorded a macro for the first number and tried to modify it. I tried using ranges for the specified fields but can't seem to get it right.
col A | col B | col C |
Number and task | Date | |
job number | AZ123 | |
sell | 5/27/2013 | |
market | 5/25/2013 | |
work | 5/21/2013 | |
start | 5/20/2013 | |
job number | AQ456 | |
sell | 5/30/2013 | |
market | 5/30/2013 | |
start | 5/29/2013 | |
job number | AD890 | |
resell | 5/1/2013 | |
rework | 4/15/2013 | |
return | 4/1/2013 | |
comment | 4/1/2013 | |
sell | 4/1/2013 | |
start | 3/1/2013 |