+ Reply to Thread
Results 1 to 3 of 3

How to transform list

  1. 02-25-2008, 05:59 AM #1
    azharinor is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    2

    How to transform list

    I have a list as follows : -

    A1 B1
    A2 B2
    A3 B3
    A4 B4
    ------------------------------------------

    I want to change the format of the list to be as follows with a space after each of the group. Can anybody help me? I have to use index, match, offset but they all failed.

    A1
    B1
    ***blank space
    A2
    B2
    ***blank space
    A3
    B3
    ***blank space
    A4
    B4
    Last edited by VBA Noob; 02-25-2008 at 06:15 AM.
    Reply With QuoteRegister To Reply
  2. 02-25-2008, 08:57 AM #2
    robert111 is offline
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    Does This Help?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 02-26-2008, 02:48 AM #3
    azharinor is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    2

    Smile Thanks

    Hei Roberts,

    Thanks for your help.

    Anyways, I have also solved the problem of dragging the formula. See attached file.

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1