+ Reply to Thread
Results 1 to 10 of 10

Split data from columns to rows

  1. 04-04-2019, 01:55 AM #1
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Split data from columns to rows

    Hi everybody.
    Can someone help me extract the data as in the attachment.
    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-04-2019, 02:14 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Split data from columns to rows

    File cannot be opened...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 04-04-2019, 02:43 AM #3
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split data from columns to rows

    Please see File
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-04-2019, 02:50 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Split data from columns to rows

    Nope.......
    Untitled.png
    Reply With QuoteRegister To Reply
  5. 04-04-2019, 03:00 AM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Split data from columns to rows 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-04-2019, 03:19 AM #6
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split data from columns to rows

    Thank you jindon.
    I would like to ask more, if the data structure is like a new file and the desired result is as in the attached file, how should Code vba be fixed?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-04-2019, 03:41 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Split data from columns to rows 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 04-04-2019, 04:22 AM #8
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split data from columns to rows

    Thanks jindon very much.
    I would like to ask more, if the input and output data are like new files, how to edit vba Code?
    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 04-04-2019, 04:31 AM #9
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Split data from columns to rows

    Don't ever do like this again.

    Mark the thread as "Solved" as your original question was solved already.
    Reply With QuoteRegister To Reply
  10. 04-04-2019, 05:44 AM #10
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split data from columns to rows

    Thank you very much.
    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. Split data into multiple columns and rows based on specific string
    By qiyusi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2018, 02:01 PM
  2. [SOLVED] Split Delimited nth Data into New Rows/columns
    By adeel1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2018, 01:55 AM
  3. [SOLVED] Transpose split data from rows to columns
    By sawan202 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2018, 08:38 PM
  4. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  5. [SOLVED] Split Rows in multipe columns - VBA
    By Vikramravikumar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2014, 12:11 PM
  6. Split one row of data to columns and rows
    By A7md in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-12-2011, 05:52 PM
  7. Split rows into columns?
    By cubsfan334 in forum Excel General
    Replies: 4
    Last Post: 03-10-2010, 12:25 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