I have data like this
Master item
039 22 36 which is in bold and component item under the same
039 15 12
039 10 52
039 10 45
039 08 45
i want it in the format mentioned below
Master item Component item
039 22 36 039 15 12
039 22 36 039 10 52
039 22 36 039 10 45
039 22 36 039 08 45
The number of components under each master item could vary and there are 2 lines of gap followed by next set of master and component items
i want the data in the format mentioned above.
Thanks in advance
Bookmarks