Pull specific data from master table to secondary table based on criteria

[kietstrom]

Thanks in advance for the support. I have a raw dataset which has multiple criteria pulled for the same account number. Meaning for 1 source ID I have 2-5 potential rows which have data, such as completed date, task name, prod site. What i am trying to do is based on the source ID, pull all associated task details into 1 row on a separate tab, rather than have all data on separate rows. I have been able to accomplish this by taking all the Source ID's removing the duplicates and pushing the unique values into the Source ID column in the new tab. Using Index(match) I am able to have the new tab "Lookup" the needed detail from the master tab and pull into the new tab in 1 row. So it works fine, but when we are using the same process over 50,000 rows, it takes a whole day to pull the data in the new format..... I am hoping there is a more efficient way to do this? I have looked at other forums with no real luck

Basic premise is to be able to take each individual Source ID and put all associated tasks on the same row, allowing us to easily see who participated in each task for the source ID.

I was not able to find a way to upload the doc but hopefully this image helps

 

[kietstrom]

Is there no efficient way to do what i described above? It takes about 5 hours to pull all the rows to columns to align under the source ID.