Excel formatting - converting from PDF into Excel

[djmatok]

I need to format the attached file but I don't know what could be the best route for me to do this.

For example cell A17 and B17 I need this information on row 19. So I would need to insert 2 more columns called Name, Account No. What formula can I use to find the best possible way to format this real quick. thanks!

[djmatok]

It seems like there isn't an easy way around this. I had to do a simple cell reference formula but I still have to manually review it.

[sandy666]

New column "Name" (After insert will be C) Row 19: =IF(AND($A17<>"",ISNUMBER($A17),$B17<>"",ISTEXT($B17)),$B17,"")
New column "Account No." (After insert will be D) Row 19: =IF(AND($A17<>"",ISNUMBER($A17),$B17<>"",ISTEXT($B17)),$A17,"")
Select both and drag down.
It works with correct data in A and B columns (most of them are), but there are few "mistakes". the numbers from A column are not in "A17" but upper or lower, the same with "B17".

[djmatok]

thank you sorry for the delay!

[sandy666]

You are welcome