Macro for Changing Format

[raj1985]

Hi,

I have an excel file where some data comes in form of vertical columns. I need to allign data appropriately . Also, if there are junk characters like #NA or spaces in the numeric field or if date field is blank, I need to skip that record.

Attached is the sample excel file with two tabs - Input and Output.

I would really appreciate if somebody can help in writing a macro for this.

[rylo]

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

[raj1985]

it worked like a charm...Thanks a lot!!!