I want to format the attached file(shown in Sheet1) as shown in (sheet2). Thanks for your help
Dec 15th 2007 #1 I want to format the attached file(shown in Sheet1) as shown in (sheet2).Thanks for your help
Dec 15th 2007 #2 Re: Re-layout Data To Flat Line DatabaseHi Gold,You need to write macro using Text to column method. It is easy to write a small macro.I think your software gives the output of text file. If you provide the actual test file i can write the macro for you.Please give me 2 or 3 different attachments so i can check my macro in your attachments.If you have access from database you can also get the inforamtion from database.Let me know if i can be any help for you ..RegardsSureshMumbai. India