Cleaning messy PDF report

[csenor]

I have a report layout that I've never seen before that I need help getting into a cleaner table format in Excel. The report has four fields. Employee ID, First Name, Last Name, Date of Birth. Can someone help me through the process? Here is an example.

EmployeeID : DOE0001	First Name : JOHN
Last Name : Doe	DOB : 1/1/1980
Employee ID : SMITH0001	First Name : MIKE
Last Name : Smith	DOB : 12/15/1985

 

[alansidman]

What do you want the end result to look like? Mind reading is tough these days.

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="tblPDF"]}[Content],
    Split1 = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(" : ", QuoteStyle.Csv), {"a", "b"}),
    Split2 = Table.SplitColumn(Split1, "Column2", Splitter.SplitTextByDelimiter(" : ", QuoteStyle.Csv), {"c", "d"}),
    AddIndex = Table.AddIndexColumn(Split2, "Index", 0, 1, Int64.Type),
    lst = List.Accumulate(Table.ToRows(AddIndex), {}, (s,c)=> 
            if Number.IsEven(c{4}) then s & List.FirstN(c,4) & List.FirstN(Record.ToList(AddIndex{c{4}+1}),4) else s),
    Result = Table.FromRows(List.Split(List.Alternate(lst, 1, 1,0),4),List.Distinct(List.Alternate(lst, 1, 1,1)))
in
    Result

Book2
	A	B	C	D	E	F	G	H
1	tblPDF			Query Output
2	Column1	Column2		Employee ID	First Name	Last Name	DOB
3	Employee ID : DOE0001	First Name : JOHN		DOE0001	JOHN	Doe	1/1/1980
4	Last Name : Doe	DOB : 1/1/1980		SMITH0001	MIKE	Smith	12/15/1985
5	Employee ID : SMITH0001	First Name : MIKE
6	Last Name : Smith	DOB : 12/15/1985
7
Sheet2