Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.

I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:

Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.

Thank you!

​Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.Thank you!   Read More

​