Reorganization of report

[Joaodasilva]

Hi everyone

I'm working with an accounting software that gives me a report of all the entities administered by us + the investors in each one of them.

This information is displayed in a very particular manner and I was wondering if there was a way to simplify it in a table with two columns: column A with the name of the company and Column B with the investor name as so.

Company Name	Investor Name
Company1	Investor1
Company1	Investor2
Company1	Investor3
Company1	Investor4
Company1	Investor5
Company1	Investor6
Company1	Investor7
Company2	Investor8
Company2	Investor9
Company2	Investor10
Company2	Investor11
Company2	Investor12
Company2	Investor13
Company2	Investor14
Company2	Investor15
Company2	Investor16
Company2	Investor17
Company2	Investor18

Will leave the file that we will be working with attached.

Note that this report can have several entities and each entity can have up to 50 investors.

Would be extremely grateful if someone could help me find a solution to this.

[cjaneczko · Accepted solution]

Does something like this work?

[CoG · Accepted solution]

Alternate Solution that doesn't depend on "EUR". Ultimately, it is very important to determine what structures exist in the data to ensure that data quality is preserved.

[Joaodasilva]

Thank you both so much for your fast help, both options work well for this case.