I have a workbook which starts with data in column B. The heading of each set of data starts with Turn No. What im trying to do is to be able to delete that row and the following 2 lines under it. It will then show LTP in column B. What I need doing with that is to be cut and pasted into column A.
This is how it looks at moment.
And I need it to look like this
Can anyone help. I also need it to carry on doing it right the way down the page.
Many Thanks
This is how it looks at moment.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | TurnNo | Loco/ | Acti | TrainWorking | Train | Cross | Days | ||||
2 | Unit | vity | Arr | Dep | Id | Rte | Refs | ||||
3 | ----------------------------------------------------------------------------------------- | ||||||||||
4 | LTPBY1751 | ||||||||||
Sheet1 |
And I need it to look like this
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | LTPBY1751 | |||||||
Sheet1 |
Can anyone help. I also need it to carry on doing it right the way down the page.
Many Thanks