Forum Discussion
Excel Help
You concluded with:
Hope the above is clear enough to get a solution
The fact that you've had nearly 60 views and no replies may tell you that your hope has not been realized. It wasn't clear enough. At the very least, post some images of the two sheets (just making sure that no names of real customers are revealed)...to help us visualize the level of detail and its organization.
If it's possible, again without revealing identities of customers, it would be even more helpful to put a link to the file if you have it on OneDrive or in Google Drive.
- mathetesApr 18, 2022Gold Contributor
Looks more like Power Query would be the necessary tool now, and on my Mac I don't have that. So here's calling some of those who know that tool. SergeiBaklan @Riny_van_Eekelen @Hans Vogelaar
- DomePApr 21, 2022Copper Contributor
- SergeiBaklanApr 18, 2022Diamond Contributor
Oops... that's better to have sample file to play and not to build the model from scratch.
- DomePApr 21, 2022Copper Contributor