Thanks a lot for the guidance. Your code works well but for some reason if only works with a small number variables assigned to Y. If I increase the number of variables, at some point it becomes incapable of grouping the various Eigenvectors tables.
I suspect the reason might be that for the number of eigen vectors reported for each 'By' categories varies slightly when I start increasing the number of variable with 65 vs 64 vectors ( I have only 2 category in my proof of concept table). As progressively decrease the number of variable, there is a point where the number of vectors becomes the same at which point, the eigenvector tables becomes combined as expected.
Is there a way to control the number of vectors that are being reported? I don't need to report all the eigen vectors, just up to 3 or 4.
Alternatively, finding a way to save each eigenvector table separately and concatenating them afterward would also work. However, I'm not sure how to loop through each 'By' categories as they will vary in name and number.