This actually used to work until a few weeks ago, where the PARENT company name, was showing in the Associated Companies column in the export. This dissapeared recently and when I contacted HS, they say apparently it was a bug (where PARENT company was showing in the Associated Company) so now is fixed. This does now seem like a bug to me; and now I ahve to play around with sheets and formulas, when the information is already there.
HS IT team, please fix this so we can actually make use of the exported data without having to resort to other programmes.