+ Reply to Thread
Results 1 to 13 of 13

List to table

Hybrid View

marcov List to table 03-05-2007, 05:05 AM
Carim Hi, ... 03-05-2007, 05:14 AM
marcov Hi Carim! Thanks for your... 03-05-2007, 05:30 AM
VBA Noob Can you post an example of... 03-05-2007, 05:40 AM
marcov Hi VBA noob :) OK. My data... 03-05-2007, 05:51 AM
VBA Noob Where did entry5 go and how... 03-05-2007, 05:53 AM
marcov ooops correction, the output... 03-05-2007, 05:54 AM
Carim may be ... ... 03-05-2007, 06:02 AM
marcov AHHH YES! That worked,... 03-05-2007, 06:36 AM
Carim Glad your problem is fixed... 03-05-2007, 06:38 AM
  1. 03-05-2007, 05:40 AM #1
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Can you post an example of your data layout and expected results

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  2. 03-05-2007, 05:51 AM #2
    marcov is offline
    Registered User
    Join Date
    03-05-2007
    Posts
    6
    Hi VBA noob

    OK. My data layout is a column which I need to break up into a table with several columns. The original layout has empty cells where it is supposed to start a new column. So:

    entry1
    entry2
    entry3
    entry4

    entry5
    entry6
    entry7
    entry8

    should become a table with two columns and 4 rows:

    entry1
    entry6
    entry2
    entry7
    entry3
    entry8
    entry4
    entry9
    Can this be done without writing a macro?

    - Marco
    Reply With QuoteRegister To Reply
  3. 03-05-2007, 05:53 AM #3
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Where did entry5 go and how did you get entry9

    What are the cell references

    Easier if you attach a file.


    VBA Noob
    Reply With QuoteRegister To Reply
  4. 03-05-2007, 05:54 AM #4
    marcov is offline
    Registered User
    Join Date
    03-05-2007
    Posts
    6
    ooops correction, the output should be (2 columns, 4 rows):

    entry1 entry5
    entry2 entry6
    entry3 entry7
    entry4 entry8
    Reply With QuoteRegister To Reply
  5. 03-05-2007, 06:02 AM #5
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    may be ...
    =OFFSET($A$1,MOD(ROW()-1,5)+(COLUMN()-1)*5,0)
    P.S. replace 5 by 4 for your last example ...
    Last edited by Carim; 03-05-2007 at 06:05 AM.
    HTH
    Carim


    Top Excel Links
    Reply With QuoteRegister To Reply
  6. 03-05-2007, 06:36 AM #6
    marcov is offline
    Registered User
    Join Date
    03-05-2007
    Posts
    6
    AHHH YES!

    That worked, thanks a lot

    Sorry I didn't attach the xls file, the upload failed...

    - Marco
    Reply With QuoteRegister To Reply
  7. 03-05-2007, 06:38 AM #7
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad your problem is fixed ...

    Thanks for the feedback
    Reply With QuoteRegister To Reply
  8. 03-06-2007, 03:14 PM #8
    hails is offline
    Registered User
    Join Date
    03-06-2007
    Posts
    1

    Question I have a similar problem

    I have a list generated by a proprietary software. It has taken the entire address list for people and put them one after the other in a single column.

    How can I move these rows out to separate columns using a macro or other step that will keep me from going through 11,000 rows to correct this data?

    Marion

    PS I am told that this is the only way this software can generate this list, so I will be dealing with this over and over again.
    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