+ Reply to Thread
Results 1 to 4 of 4

Convert List of Data in Row to a Column

  1. 07-13-2021, 05:26 PM #1
    Timmer2005
    Timmer2005 is offline
    Registered User
    Join Date
    02-08-2021
    Location
    Michigan, USA
    MS-Off Ver
    O365
    Posts
    48

    Convert List of Data in Row to a Column

    Hello,

    I am looking for a formula to take data that is currently in a row layout and move it to a column layout. Here's what I am looking to do:

    Current Data is:

    Data1
    Data2
    Data3

    But I want it to show in excel this way:
    Data1 | Data2 | Data3

    Is there a formula for this as I want it to be dynamic so when data updates in the column it auto updates in the row. Thank you
    Reply With QuoteRegister To Reply
  2. 07-13-2021, 05:32 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Convert List of Data in Row to a Column

    Assuming the data starts in cell A2 down, try in cell B2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    copied across as far as you need it.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-13-2021, 06:23 PM #3
    Timmer2005
    Timmer2005 is offline
    Registered User
    Join Date
    02-08-2021
    Location
    Michigan, USA
    MS-Off Ver
    O365
    Posts
    48

    Re: Convert List of Data in Row to a Column

    Thank you this worked.
    Reply With QuoteRegister To Reply
  4. 07-13-2021, 06:40 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Convert List of Data in Row to a Column

    You're welcome. Thanks for the rep.
    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)

Similar Threads

  1. [SOLVED] Convert Cells with Individual Lists to One List in a Column
    By smokinbadger in forum Excel General
    Replies: 2
    Last Post: 01-02-2020, 08:11 PM
  2. [SOLVED] Convert multiple column list to 1 linear list
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-16-2016, 06:31 AM
  3. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  4. Convert Array to 2-Column List
    By boboliverjr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2013, 06:29 PM
  5. [SOLVED] Convert Matrix to multi column list
    By nipeeter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 07:38 AM
  6. Convert Horizontal data into a 'Cummulative' (one-column) Vertical List
    By Gabino21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2012, 11:28 PM
  7. convert list to column
    By guthrie in forum Excel General
    Replies: 3
    Last Post: 10-21-2010, 01:57 PM

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