Results 1 to 7 of 7

How to combine multiple rows of data into a single row (with multiple columns)?

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    kuwait
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to combine multiple rows of data into a single row (with multiple columns)?

    Hello All,

    I am a basic user of Excel. I do not know Macros or VBA. I have a task which I hope you will be able to help. The task is given below.
    I have an Excel datasheet with 4 columns and 4485 rows.
    I want to rearrange this data to get a 69 X 260 matrix i.e. 69 rows & 260 columns.
    That means, from the present datasheet, each block of 65 rows should be arranged in a single row in the following way.
    Please see the attached sample workbook

    In the table below, the red chracters are actual data. The top row & the left-row shows the columns & rows respectively in Excel.
    Present data:

    A B C D
    1 101 102 103 104
    2 105 106 107 108. . . . .
    . . . . .
    65 357 358 359 360
    66 361 362 363 364






    Required data:

    A B C D . . IY IZ
    1 101 102 103 104 . . 359 360
    2 361 362 363 364 . . 619 620
    . . . . . . . . .
    . . . . . . . . .
    69 6901 6902 6903 6904 . . 7159 7160

    Please see the attached sample workbook
    I want your expert help in resolving my problem.
    Thanks a lot.
    Attached Files Attached Files
    Last edited by probeen; 10-13-2010 at 07:53 AM. Reason: Titlle not appropriate

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1