I am a newbie to the forum. I am trying to tackle this large 60,000 row dataset of contact information.
I have attached an xls with the before and after (goal).
I attempted a number of transpose functions but it is difficult due to the number of inconsistent variables:
- Differing attributes such as missing fax, tel, or email rows
- There is a Lead Agency that is to be applied to all employees of that agency below that
- Repeated Lead Agency titles due to page breaks in the PDF
At this point, I'm not exactly sure where to go with it.