+ Reply to Thread
Results 1 to 5 of 5

Copy data from row to multiple columns with fixed rows

  1. 12-17-2020, 09:07 AM #1
    sashish76
    sashish76 is offline
    Registered User
    Join Date
    12-17-2020
    Location
    Abu Dhabi
    MS-Off Ver
    Office 365
    Posts
    2

    Copy data from row to multiple columns with fixed rows

    Hello to all,

    I am trying to make one data table where I have to make 3 sets of column data and fixed set of rows. And paste next set of data below those row. I am able to split the data using following code to number of cuts but cannot place below rows. Please help solving the problem. I am attaching excel sheet for the same.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-17-2020, 10:26 AM #2
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: Copy data from row to multiple columns with fixed rows

    Two ways:
    Sheet formulas
    Paste the formula into F1 of sheet 1 and copy right and down. 
    Please Login or Register  to view this content.
    VBA code. 
    Please Login or Register  to view this content.
    Best Regards,
    Maras.
    Reply With QuoteRegister To Reply
  3. 12-17-2020, 10:41 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Copy data from row to multiple columns with fixed rows

    Here is the code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 12-18-2020, 11:24 PM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Copy data from row to multiple columns with fixed rows

    If problem is solved Pl mark the thread SOLVED.
    Reply With QuoteRegister To Reply
  5. 12-29-2020, 09:06 AM #5
    sashish76
    sashish76 is offline
    Registered User
    Join Date
    12-17-2020
    Location
    Abu Dhabi
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Copy data from row to multiple columns with fixed rows

    Hi Again,

    I have been doing some modifications but seems stuck. Now I have to do it for 14 columns together and since there are formula based values, copying is not working. Any way to paste values? 

    Please Login or Register  to view this content.
    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. Copy data headings in columns and paste them into multiple rows in different columns
    By CV_Brett in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-21-2020, 03:27 AM
  2. VBA to copy multiple rows data into singlet row into multiple columns
    By Abdur_rahman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2020, 12:46 PM
  3. [SOLVED] Select Cells Individually, Fixed Columns, Fixed Rows, Every Other Row
    By ZooTV92 in forum Excel General
    Replies: 13
    Last Post: 10-13-2015, 04:17 AM
  4. how to copy/past data from multiple rows/columns to multiple columns one single row?
    By giovanna1 in forum Excel General
    Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  5. Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns
    By demip in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2013, 09:49 AM
  6. [SOLVED] copy across multiple rows and columns the data to one column removing dupilicates
    By eabeauchamp in forum Excel General
    Replies: 8
    Last Post: 07-17-2012, 03:54 PM
  7. how to copy multiple cell rows with increasing fixed number every 10 rows
    By climate in forum Excel General
    Replies: 0
    Last Post: 08-30-2010, 10:30 PM

Tags for this Thread

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