+ Reply to Thread
Results 1 to 6 of 6

Arrange data to the be the same row

  1. #1
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Arrange data to the be the same row

    Hi all friends and experts,

    I would like to ask your help,
    I have some data, which is need it to be the same row

    Example:
    Arrage data to the same row.JPG


    Is there any macro that will help make it faster than do it manually,?
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Arrange data to the be the same row

    Create a Pivot Table as shown in the attached.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Arrange data to the be the same row

    Hi Alansidmam,

    That would be great , do you have any Macro to arrange this, instead of Pivot table?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Arrange data to the be the same row

    No, but you can record a macro that replicates creating a Pivot Table. Then if you need to modify it in any fashion, then post it here with your concerns.

  5. #5
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Arrange data to the be the same row

    Please help to create any macro

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Arrange data to the be the same row

    For the data layout in your workbook.
    Please Login or Register  to view this content.

+ 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. [SOLVED] Re arrange the data
    By abdumon7 in forum Excel General
    Replies: 18
    Last Post: 10-08-2017, 07:07 AM
  2. Arrange the data
    By jame123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2017, 11:34 AM
  3. re-arrange data
    By benong in forum Excel General
    Replies: 0
    Last Post: 08-10-2010, 02:23 AM
  4. Arrange Data
    By RemyD in forum Excel General
    Replies: 3
    Last Post: 05-07-2009, 02:00 PM
  5. Arrange raw data
    By peet_dk in forum Excel General
    Replies: 1
    Last Post: 08-06-2008, 04:27 AM
  6. Re-arrange Data
    By herverob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2008, 09:45 AM
  7. Data Re-arrange
    By Miles Willis in forum Excel General
    Replies: 2
    Last Post: 11-27-2006, 02:35 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