+ Reply to Thread
Results 1 to 8 of 8

Transpose and Concatenate help

Hybrid View

Ainsley Transpose and Concatenate help 05-06-2015, 10:52 AM
igoodable Re: Transpose and Concatenate... 05-06-2015, 10:55 AM
Ainsley Re: Transpose and Concatenate... 05-06-2015, 11:08 AM
mahju Re: Transpose and Concatenate... 05-06-2015, 11:10 AM
Ainsley Re: Transpose and Concatenate... 05-06-2015, 11:19 AM
mahju Re: Transpose and Concatenate... 05-06-2015, 11:23 AM
AlKey Re: Transpose and Concatenate... 05-06-2015, 11:34 AM
AlKey Re: Transpose and Concatenate... 05-06-2015, 11:29 AM
  1. 05-06-2015, 10:55 AM #1
    igoodable is offline
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: Transpose and Concatenate help

    =CONCATENATE(A2," ",A3," ",A4 etc....)
    Reply With QuoteRegister To Reply
  2. 05-06-2015, 11:08 AM #2
    Ainsley is offline
    Registered User
    Join Date
    02-27-2006
    Location
    Oxford England
    MS-Off Ver
    2007
    Posts
    54

    Re: Transpose and Concatenate help

    OK, but is there a quicker way to write that formula. My list may well become hundreds of lines long soon and typing each cell followed by " " will take forever.

    Any suggestions ?
    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. Group, Transpose & Concatenate based on value of a column
    By @MeDaveT in forum Excel General
    Replies: 1
    Last Post: 08-28-2014, 03:53 PM
  2. VBA Macro to Transpose Columns to Rows AND Concatenate Afterwards
    By ljanak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 03:16 PM
  3. [SOLVED] VBA or forumla. Concatenate, transpose
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 04:01 PM
  4. [SOLVED] Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item
    By cocolete in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2012, 10:01 AM
  5. TRANSPOSE ROWS INTO COLUMS without useing PASTE SPECIAL; TRANSPOSE
    By annepopa in forum Excel General
    Replies: 2
    Last Post: 02-19-2007, 04:53 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