+ Reply to Thread
Results 1 to 2 of 2

Separate Data from two rows to four rows!!

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    141

    Separate Data from two rows to four rows!!

    Hiiii,

    Thanks for looking by..

    i have attached an excel sheet.

    i have a sheet named input..where i have a table.

    i have made a pivot from this table in the pivot sheet.

    my problem is i dont want the amounts h and i to come together

    i want it separate as shown in the output required.

    instead of two entries i will have four entries for example.

    in my actual scenario i have many entries..but i have just put two entries in the sheet.

    is there a way i can do this??

    Many Thanks

    Gokz
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Separate Data from two rows to four rows!!

    Hi Gokz

    Using a helper column it seems to work (as attached)

    Regards

    Alastair
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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