Transposing question

[allholy1]

Hey everyone,

First post here, woo hoo! This seems like a really helpful website and I wish I would have stumbled on it a long time ago.

I have the following format of data:

Time in ms Task Filename Filetype file size
3626 ExportToJpegTask 00524c99-f62a-420a-95a3-8deb895147f9-4 ppt 869888
2403 ExportToPdfTask 00524c99-f62a-420a-95a3-8deb895147f9-4 ppt 869888
2899 ExportToPptTask 00524c99-f62a-420a-95a3-8deb895147f9-4 ppt 869888
2182 ExportToPptxTask 00524c99-f62a-420a-95a3-8deb895147f9-4 ppt 869888
1291 ExportToJpegTask 00543006-97c0-407b-8123-00add40d13a3-2 ppt 568832
2369 ExportToPdfTask 00543006-97c0-407b-8123-00add40d13a3-2 ppt 568832
2493 ExportToPptTask 00543006-97c0-407b-8123-00add40d13a3-2 ppt 568832
2119 ExportToPptxTask 00543006-97c0-407b-8123-00add40d13a3-2 ppt 568832
1868 ExportToJpegTask 0069b076-9612-423b-bb2b-d40516a04a1b-1 ppt 2048000
2650 ExportToPdfTask 0069b076-9612-423b-bb2b-d40516a04a1b-1 ppt 2048000
2977 ExportToPptTask 0069b076-9612-423b-bb2b-d40516a04a1b-1 ppt 2048000
2351 ExportToPptxTask 0069b076-9612-423b-bb2b-d40516a04a1b-1 ppt 2048000
2991 ExportToJpegTask 007c5c74-945f-49e0-b174-66d20f3ae875-1 ppt 488448
3071 ExportToPdfTask 007c5c74-945f-49e0-b174-66d20f3ae875-1 ppt 488448
2633 ExportToPptTask 007c5c74-945f-49e0-b174-66d20f3ae875-1 ppt 488448
2212 ExportToPptxTask 007c5c74-945f-49e0-b174-66d20f3ae875-1 ppt 488448

I need it to look like this:
MS Filename Filetype file size ExportToJpegTask ExportToPdfTask ExportToPptTask ExportToPptxTask

3626 00524c99-f62a-420a-95a3-8deb895147f9-4 ppt 869888 3626 2403 2899 2182
1291 00543006-97c0-407b-8123-00add40d13a3-2 ppt 568832 1291 2369 2493 2119
1868 0069b076-9612-423b-bb2b-d40516a04a1b-1 ppt 2048000 1868 2650 2977 2351
2991 007c5c74-945f-49e0-b174-66d20f3ae875-1 ppt 488448 2991 3071 2633 2212


I was looking at this post, and it appears that it is very very similar to what I am doing and tried running the code that was posted by pike, but I am getting an out of memory error. This is running on a beefy server so I feel like it's something wrong with the code, though this will be running against 10,000+ rows. I've played around with a few different solutions and couldn't find one that works. Does anyone know of a better way?

Thanks in advance

**Edit: Sorry, I saw another transposing question in here before so I thought this would be the right forum to put it in. It probably belongs in the VBA forum.