create new table after get the line of information that i want form txt ! but it has different line space

i'm very sorry that i cant find the right english words to explain for this problem (i'm foreigner)

this is my question how can i import it to another sheet (in same worksheet) as a nice table.

what i need to use VBA or Fucntion

Thank You

AttachmentSize
ABC2.txt4.28 KB
Result that i want.xlsx9.37 KB
RangeToTabDelimitedTextFile_Ans.xls42.5 KB
Almir's picture

create new table after get the line of information that i want f

Neither VBA nor function: Data, From Text, Select your text file, Use "Delimited", for separators check "Space" and "Other". In "Other" type ":". Press "Finish".