Text Extraction using headers as reference

Is there a way to extract the information out of each field that will be listed as headers as reference for the macro?

Please have a look,

3 worksheets.
1) "Raw data"
2) "Output" - reformatting of the raw data
3) "Example" - expected result

Text Extractor.xlsm

Tr this:-
Results on sheet "Output" starts "B3".

Please Login or Register  to view this content.

Regards Mick

Please Login or Register  to view this content.

May I know why the need to expand the array size by 4 times?

Please Login or Register  to view this content.

also, how does this (1) work? does it mean (0) = first element / (1) = second element / (2) = third element

Please Login or Register  to view this content.

Ref:- "Rng.count *4. Actually you don't need (rng.count *4), Rng.count would have done , I was thinking each row in a used cell would have 4 lines, but it actually has just one line.
The general purpose was to have an array large enough to cover all the used data. When you place the filled array in the "OutPut" sheet you only show the amount of the array thats used .i.e variable "c".
Ref:- Split array. When you create a array using the "Split" function, it is a zero based array, so the first element of array "Sp" will be Sp(0)
Hope that helps.
Regrds Mick