Forum Discussion
bigrig33
2 years agoNew Member
5000 Rows of Data with duplicate data
Apologies if something similar has been posted. I have a table with 5281 rows of data. I have taken screenshot, data hid as priviliged. so the first two rows are the same person and he did two t...
mussaenda
2 years agoCommunity Champion
I understand, but have you tried the suggestion? That is why it is important to have a star schema when building your data. For situations like this.
bigrig33
2 years agoNew Member
mussaenda i tried it but unfortunately doesn't seem to be working, see I receive this data on two seperate sheets, I don't create the data, so alot of cleanup, but ultimately, I want to know who has completed training and who hasn't but I don't want 3 or 4 records per person, I just want one row to show all the information relating to that person including there trainings and start dates for the training