Forum Discussion

bigrig33's avatar
bigrig33
New Member
2 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
bigrig33's avatar
bigrig33
New Member
2 years ago

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

mussaenda's avatar
mussaenda
Community Champion
2 years ago

Please provide a sample data that we can copy to provide with a solution

  • bigrig33's avatar
    bigrig33
    New Member
    2 years ago

    Hi mussaenda 

    So I had to edit data as some sensitive, but you will get the jist. I have multipe entries of similar data based over 5200 rows, I want just one row per entry per payno but i want all the data to follow, so lets take the first two lines, can I have one entry for those two lines,but both training entries and also start dates on the same line. 

     

     

    • mussaenda's avatar
      mussaenda
      Community Champion
      2 years ago

      Hi bigrig33 ,


      you can do like this to have one entry


      or you can do like this

       

      or you can do like this and create a star schema

       

      other than those, i hope others will meet your requirements.

      Hope this helps