Amalgamating ranges and removing empty cells

[picklefactory]

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

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

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	397	BASIC HOURS	54	397	SHIFT ALLOWANCE	54					397	BASIC HOURS	54
3	494	BASIC HOURS	26.5				494	HOL PAY	27		494	BASIC HOURS	26.5
4	392	BASIC HOURS	40								392	BASIC HOURS	40
5	566	BASIC HOURS	42								566	BASIC HOURS	42
6	647	BASIC HOURS	40								647	BASIC HOURS	40
7	645	BASIC HOURS	22	645	SHIFT ALLOWANCE	22	645	HOL PAY	22		645	BASIC HOURS	22
8	657	BASIC HOURS	31.5								657	BASIC HOURS	31.5
9	683	BASIC HOURS	27				683	HOL PAY	15		683	BASIC HOURS	27
10	685	BASIC HOURS	17.75								685	BASIC HOURS	17.75
11	688	BASIC HOURS	42								688	BASIC HOURS	42
12	689	BASIC HOURS	32.5				689	HOL PAY	9		689	BASIC HOURS	32.5
13	693	BASIC HOURS	42								693	BASIC HOURS	42
14	695	BASIC HOURS	33								695	BASIC HOURS	33
15	696	BASIC HOURS	25.5								696	BASIC HOURS	25.5
16	697	BASIC HOURS	40								697	BASIC HOURS	40
17	698	BASIC HOURS	40								698	BASIC HOURS	40
18	372	BASIC HOURS	42								372	BASIC HOURS	42
19	505	BASIC HOURS	44	505	SHIFT ALLOWANCE	44					505	BASIC HOURS	44
20	604	BASIC HOURS	23								604	BASIC HOURS	23
21							147	HOL PAY	44		222	BASIC HOURS	36
22											397	SHIFT ALLOWANCE	54
23	222	BASIC HOURS	36								645	SHIFT ALLOWANCE	22
24											505	SHIFT ALLOWANCE	44
25											494	HOL PAY	27
26											645	HOL PAY	22
27											683	HOL PAY	15
28											689	HOL PAY	9
29											147	HOL PAY	44
30
Sheet6

Cell Formulas
Range	Formula
K2:M29	K2	=LET(d,VSTACK(A2:C100,D2:F100,G2:I100),FILTER(d,INDEX(d,,1)<>""))
Dynamic array formulas.

 

[picklefactory]

You lot are far to clever for your own good!!!! I've never even heard of a LET formula.
Brilliant, works a treat.
Thank you very muchly indeed Fluff, I've been scratching my head on it for hours and it took you about 2 minutes

 

[Fluff]

You're welcome & thanks for the feedback.