Transposing question

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.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Make sure the sample clearly demonstrates BEFORE / AFTER examples.

This will give you a start:

=IF(MID(A1,14,8)="JpegTask",MID(A1,1,LEN(A1))&" "&LEFT(OFFSET(A1,1,0),4)&" "&LEFT(OFFSET(A1,2,0),4)&" "&LEFT(OFFSET(A1,3,0),4)," ")

There will be someone who can do a VB solution which will be more robust

edvwvw

Remove the BEFORE line at the top so the data sits in A1 properly.

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

The code is meant as a starting point. It is expected you will edit it for your final needs. Surely you can edit the "Sheet1" to whatever you need it to be, or replace it with ActiveSheet.Copy if you're SURE you'll never activate the macro from the wrong sheet.