View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred[_21_] Fred[_21_] is offline
external usenet poster
 
Posts: 18
Default Rearrange row data

Anybody know how I can rearrange following example:
I actually have columns C-T after A and B

Name ID Acct Fund
--------------------------------------------
Fred fred01 AB123 23
Fred fred01 BJ854 45
Iain iain01 ZT675 23
Toby toby01 DQ678 23
Toby toby01 LS951 45
Sarah sarah01 PL645 23

To look like this:
Name ID Acct Fund Acct Fund
-------------------------------------------------------------------------
Fred fred01 AB123 23 BJ854 45
Iain iain01 ZT675 23
Toby toby01 DQ678 23 LS951 45
Sarah sarah01 PL645 23

Thanks!!