+ Reply to Thread
Results 1 to 3 of 3

Re: Arrange horizontal data to be vertical

  1. 12-16-2015, 07:02 AM #1
    markland
    markland is offline
    Registered User
    Join Date
    12-15-2015
    Location
    Bangkok,Thailand
    MS-Off Ver
    345
    Posts
    3

    Re: Arrange horizontal data to be vertical

    Hi all,

    Sorry to re-post again because i forgot put a sample file in last times.

    I would like formula to rearrange multiple data in horizontal to vertical for my stock management.

    Please find the attachment

    Thank you in advance Book2.xlsx
    Reply With QuoteRegister To Reply
  2. 12-16-2015, 07:59 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Arrange horizontal data to be vertical

    Created a helper column H
    H2 
    Please Login or Register  to view this content.
    Try this formula and copy towards down up to H10 then
    A15 
    Please Login or Register  to view this content.
    B15 
    Please Login or Register  to view this content.
    C15 
    Please Login or Register  to view this content.
    Try the above and copy towards down
    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 12-16-2015, 10:49 AM #3
    markland
    markland is offline
    Registered User
    Join Date
    12-15-2015
    Location
    Bangkok,Thailand
    MS-Off Ver
    345
    Posts
    3

    Re: Arrange horizontal data to be vertical

    It's great

    Thank Siva
    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. Arrange horizontal data to be vertical
    By markland in forum Excel General
    Replies: 4
    Last Post: 12-15-2015, 12:04 PM
  2. Re-arrange data from vertical to horizontal
    By Haha88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2015, 02:37 AM
  3. Arrange horizontal data to vertical through cut, paste, loop
    By kcheeser in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-26-2014, 04:12 PM
  4. Arrange multiple periods with data to one vertical period with data
    By coolboy3222 in forum Excel General
    Replies: 1
    Last Post: 11-06-2013, 11:21 AM
  5. How to arrange vertical Vcards column into horizontal rows ?
    By m.rizeg in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 07-26-2013, 10:00 PM
  6. [SOLVED] how to arrange slicer look from vertical to horizontal?
    By koi in forum Excel General
    Replies: 1
    Last Post: 10-29-2012, 03:39 AM
  7. Arrange vertical string into multiple horizontal columns
    By tribalgifts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2009, 02:20 AM

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