+ Reply to Thread
Results 1 to 2 of 2

Spreading column information across rows

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    nigeria
    MS-Off Ver
    2007
    Posts
    4

    Spreading column information across rows

    Hello All,

    Please i really need urgent help as I have a strict timeline to meet and have been battling with this issue for hours now.

    I am trying to copy information from a word doc into excel but whenever I paste instead of it to spread the data across the rows in keeps everything in a single column making it difficult for me to use the data. it has thousands of rows and i can't start manually editing one by one.

    What i need is a way to spread this information across the rows so i can select and copy easily.

    details of how it looks when imported to excel and how its supposed to be can be found in the attachment.

    Book1.xlsx

    Thanks in advance. Please save a job.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Spreading column information across rows

    Assuming your data import is in Sheet2 Column A, and you want to transform this data into the layout in Sheet 2 Columns F:N?

    A small macro will be the quickest and easiest way to transform your data:

    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spreading column information across rows
    By ismonene in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2014, 12:07 PM
  2. Need duplicate rows with different column information to only be on one row
    By LoveUsingExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 11:05 AM
  3. Transposing column information into multiple rows
    By lgomathi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2011, 03:31 PM
  4. Convert column information to rows
    By udayk4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2009, 02:40 AM
  5. Fill rows with column information
    By Tim in forum Excel General
    Replies: 2
    Last Post: 04-05-2006, 09:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1