Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help With Reformatting
There are times when I have to dump financial information from the AS400 to
Excel. When I do, it comes down in the following format: ACCOUNT/JOB # DESCRIPTION 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA VL02527 MATHEWS GINA VL02537 MICHAELS MARG VL02537 MICHAELS MARG 8111-000-00000 DEPRECIATION APRIL 07 DEPR ENTRY AUG 07 DEPR ENTRY DEC 07 DEPR ENTRY FEB 07 DEPR ENTRY I need an easy way to move the account # and account name to the first two columns like this: 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA 7618-000-00000 COMMISSIONS VL02537 MICHAELS MARG 7618-000-00000 COMMISSIONS VL02537 MICHAELS MARG 8111-000-00000 DEPRECIATION APRIL 07 DEPR ENTRY 8111-000-00000 DEPRECIATION AUGUST 07 DEPR ENTRY 8111-000-00000 DEPRECIATION DECE 07 DEPR ENTRY 8111-000-00000 DEPRECIATION FEBR 07 DEPR ENTRY I can do it manually, but there are 5,000+ lines and it takes a lot of time. Is there any way to automate this? Thanks. Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reformatting dates | Excel Discussion (Misc queries) | |||
Auto - reformatting | Excel Discussion (Misc queries) | |||
Reformatting a column | Excel Discussion (Misc queries) | |||
Reformatting numbers | Excel Discussion (Misc queries) | |||
need help reformatting spreadsheet | Excel Discussion (Misc queries) |