Results 1 to 11 of 11

Create 1 long list from 3 columns?

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2006
    Posts
    36

    Create 1 long list from 3 columns?

    My data is set up as

    A B C
    1 A B C
    2 D E F
    3 G H I


    How Can I make that data appear as

    A
    1 A
    2 B
    3 C
    4 D
    5 E
    6 F
    7 G
    8 H
    9 I

    Where is takes the row and keeps transposing it down 3 lines at a time?

    Thanks!
    Last edited by theblade24; 01-04-2014 at 01:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to create daily average from LONG list of hourly data
    By wrf_89 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-13-2017, 12:20 PM
  2. Create a list for specfied person from long list
    By Jayess in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2013, 06:15 AM
  3. Replies: 1
    Last Post: 05-21-2006, 12:45 AM
  4. print a long list with 2 columns
    By Bucky in forum Excel General
    Replies: 2
    Last Post: 03-10-2006, 02:15 PM
  5. How do I add grid lines to a LONG list with 3 columns?
    By Eclectic Creations & Collectibles in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-09-2006, 09:35 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1