Transform Data Set

**whitehead6682** · 02-15-2011, 05:45 PM

Hi Guys

The solutions you gave me worked fantastic within my example, however I am really struggling to replicate this against my SAP dump.

I have attached 2 files..

Problem1 = This is the Info dump in from SAP, I have highlighted the Information i need to retain.

Problem2 = What I want if possible

Does anybody have a Macro I can use to make this happen, I think the amount of blank space and change in material is what is giving me real trouble.

Thanks for any help or guidance at all

Regards

Chris...

**DonkeyOte** · 02-16-2011, 03:42 AM

Chris, to all intents and purposes this is a new question (from formula to VBA routine) - we ask you keep threads specific to the original question.

Given the above (and lack of posts) I have on this occasion moved your latest question to a new thread but going forward please bear the above in mind.

On a final note - it's often easier/better to just have a single sample file with before/after sheets rather than separate files with single sheets.

**whitehead6682** · 02-16-2011, 06:16 AM

Thanks DonkeyOte, I will bear this in mind for future posts.

**snb** · 02-16-2011, 06:30 AM

Please Login or Register  to view this content.

**whitehead6682** · 02-16-2011, 09:17 AM

Thanks snb!

This seems to be nearly perfect for what I am after, however... would it be possible to retain column 'K' also? - Sorry I omitted this from my initial request for help.

Plus would it be possible to run the Material parallel with the delivery information?

Thanks again

Chris...