Macro to convert 11 Columns Data Set to 14 Columns Database

Hello All Experts,

My office version is 2010

I have a data in 11 Columns from Col A to Col K

Row 1 only shows the Column Number for explanation purpose only

Actual Data Headings will Start in Row 1

Sheet Data shows the original

I have strike-out the Data which is not required on the Desired sheet

Sheet Desired is my requirement please

Col A is PN which is two Characters followed by Numbers
Eg AB##/###### - see in sheet Data

Col B - PT is text value followed by FL, CL, PR. It will always be one of these values

Col B needs to split into two Col C and D as shown on the desired Sheet

Col D as shown in color

Col E to be split into two Columns as shown on the desired sheet

Col G a new Col with fix value M1

Col H is split of Col E

Col I to Col N as shown in color

The data shown a small set and actual data is several thousand rows in similar pattern
Col A (PN) can be 1 to several rows

Any help would be greatly appreciated

TIA

Please Login or Register  to view this content.

Thanks Jindon for your prompt response.

Please see the attached sample (V1), sheet name is YourMacro

Result in the output sheet should be from Row2
Col F and Col H has some small issues.
Please see my remarks in YourMacro sheet under respective Columns

Regards

Sorry, but if you don't even test the code I posted in the other thread, I am reluctant to help you.

Hello Jindon,
I have tested your code in the other thread.
I had even mentioned sorry
Sorry once again.
You have been a great help always to this group and especially people like me

Thanks and regards

Hello Jindon,
Sorry I just realized my mistake
While posting the file the module was not there

Now I have pasted the Module1. Please recheck again and help

And sorry for my mistake once again

Please help

Regards
Rashid