Single cell data to multiple rows & columns

[learneagerly]

Hi all,
I have some data extracted from pdf file.It gives a table data in a single cell.
I have attached the sample file for input format I have with me & the expected result as well. Even if I can get the conversion of only cell B4 in proper table matrix; it's fine rest I can manage manually.
only thing is cell B4 info can vary in size & there could be tabs in between component names and molecular wt columns. I am not sure how pdf extract really will be everytime.

I hope my query is clear. lf you need any more info please let me know.

Thanks in advance... Looking forward to the solution.

 

[bosco_yip]

Try

1] "Sr. No." A13, copied down :

=IFERROR(INDEX(A$3:A$7,(B$3:B$7,CHAR(10),))+1>=COLUMN($A:$J)),ROW(A1))),"")

2] "Description" B13, copied across to C13 and all copied down :

=IF(COUNTIF($A$13:$A$22,$A13)<2,IF(B$12="Description",VLOOKUP($A13,$A$3:$C$7,2,0),""),TRIM(MID(SUBSTITUTE(" "&SUBSTITUTE(SUBSTITUTE(TRIM(VLOOKUP($A13,$A$3:$C$7,2,0))," W","_W"),CHAR(10)," ")," ",REPT(" ",50)),((COUNTIF($A$13:$A13,$A13)-1)*2+COLUMNS($A:A))*50,50)))

3] "Comment" D13, copied down :

=VLOOKUP($A13,$A$3:$C$7,3,0)&""

Regards
Bosco