picklefactory
Well-known Member
- Joined
- Jan 28, 2005
- Messages
- 506
- Office Version
- 365
- Platform
- Windows
Hi folks
Hoping for some help please..... as always
Not sure how to even ask the right question on this one. I'm adding a sheet to an existing payroll timesheet WB and I need to somehow merge 3 sets of 3 columns into a single set of 3 columns. Each source set can contain blank rows, which I also need to remove. The best thing I can think of to explain is to show you what I have as source, and what I'd like it to finish up as. I have no idea if this would be VBA or an array formula maybe, I have no preference. Any help or advice as to how to go about it would be gratefully received.
This is the source data format
And this is how I'd like it to end up if at all possible.
Hoping for some help please..... as always
Not sure how to even ask the right question on this one. I'm adding a sheet to an existing payroll timesheet WB and I need to somehow merge 3 sets of 3 columns into a single set of 3 columns. Each source set can contain blank rows, which I also need to remove. The best thing I can think of to explain is to show you what I have as source, and what I'd like it to finish up as. I have no idea if this would be VBA or an array formula maybe, I have no preference. Any help or advice as to how to go about it would be gratefully received.
This is the source data format
397 | BASIC HOURS | 54 | 397 | SHIFT ALLOWANCE | 54 | |||
494 | BASIC HOURS | 26.5 | 494 | HOL PAY | 27 | |||
392 | BASIC HOURS | 40 | ||||||
566 | BASIC HOURS | 42 | ||||||
647 | BASIC HOURS | 40 | ||||||
645 | BASIC HOURS | 22 | 645 | SHIFT ALLOWANCE | 22 | 645 | HOL PAY | 22 |
657 | BASIC HOURS | 31.5 | ||||||
683 | BASIC HOURS | 27 | 683 | HOL PAY | 15 | |||
685 | BASIC HOURS | 17.75 | ||||||
688 | BASIC HOURS | 42 | ||||||
689 | BASIC HOURS | 32.5 | 689 | HOL PAY | 9 | |||
693 | BASIC HOURS | 42 | ||||||
695 | BASIC HOURS | 33 | ||||||
696 | BASIC HOURS | 25.5 | ||||||
697 | BASIC HOURS | 40 | ||||||
698 | BASIC HOURS | 40 | ||||||
372 | BASIC HOURS | 42 | ||||||
505 | BASIC HOURS | 44 | 505 | SHIFT ALLOWANCE | 44 | |||
604 | BASIC HOURS | 23 | ||||||
147 | HOL PAY | 44 | ||||||
222 | BASIC HOURS | 36 | ||||||
And this is how I'd like it to end up if at all possible.
397 | BASIC HOURS | 54 |
494 | BASIC HOURS | 26.5 |
392 | BASIC HOURS | 40 |
566 | BASIC HOURS | 42 |
647 | BASIC HOURS | 40 |
645 | BASIC HOURS | 22 |
657 | BASIC HOURS | 31.5 |
683 | BASIC HOURS | 27 |
685 | BASIC HOURS | 17.75 |
688 | BASIC HOURS | 42 |
689 | BASIC HOURS | 32.5 |
693 | BASIC HOURS | 42 |
695 | BASIC HOURS | 33 |
696 | BASIC HOURS | 25.5 |
697 | BASIC HOURS | 40 |
698 | BASIC HOURS | 40 |
372 | BASIC HOURS | 42 |
505 | BASIC HOURS | 44 |
604 | BASIC HOURS | 23 |
222 | BASIC HOURS | 36 |
397 | SHIFT ALLOWANCE | 54 |
645 | SHIFT ALLOWANCE | 22 |
505 | SHIFT ALLOWANCE | 44 |
494 | HOL PAY | 27 |
645 | HOL PAY | 22 |
683 | HOL PAY | 15 |
689 | HOL PAY | 9 |
147 | HOL PAY | 44 |