Results 1 to 11 of 11

Transpose a vertical list horizontally with an added space in excel and googlesheets NoVBA

Threaded View

  1. 06-28-2021, 11:17 PM #1
    smart_beta
    smart_beta is offline
    Registered User
    Join Date
    05-16-2020
    Location
    Lima
    MS-Off Ver
    2019
    Posts
    25

    Transpose a vertical list horizontally with an added space in excel and googlesheets NoVBA

    Hi Excel People!

    I have a list of stocks saved vertically in google sheets. I'd like to transpose them horizontally automatically with and added space in between each stock ticker. what formula can I write to accomplish this? I've attached a sample for clarity.

    Thank you kindly.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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] Scroll bar is added horizontally by default - how to rotate it making it vertical?
    By Graxon in forum Excel General
    Replies: 2
    Last Post: 10-24-2019, 11:21 AM
  2. Count of Names in Vertical List(according to criteria), then arrange Horizontally...
    By ClickingNoise in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-14-2016, 09:24 AM
  3. [SOLVED] autofill vertical list horizontally with 2 blank cells in-between each list item
    By Phily915 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2014, 08:15 PM
  4. [SOLVED] Macro to transpose vertical data horizontally from one sheet to another
    By Scott_88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2013, 06:27 AM
  5. Vertical List to Sort Horizontally on another sheet
    By ncurran217 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2013, 02:01 PM
  6. Referencing vertical list horizontally, with gap in cells
    By tercuk in forum Excel General
    Replies: 4
    Last Post: 03-11-2013, 06:43 PM
  7. items in vertical list, how to organize them in horizontally?
    By xianwinwin in forum Excel General
    Replies: 3
    Last Post: 12-14-2006, 01:58 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