For whatever reason the companies house data comes with multiple columns that serve similar purpose.
The most important columns to transition from multi to singular with separate rows are the company names as it makes searching for a company by past name trivial.
For whatever reason the companies house data comes with multiple columns that serve similar purpose.
The most important columns to transition from multi to singular with separate rows are the company names as it makes searching for a company by past name trivial.