+ Reply to Thread
Results 1 to 3 of 3

Conversion of table into list

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    KSA
    MS-Off Ver
    2010
    Posts
    1

    Conversion of table into list

    Hi

    I want to rearrange data from table to a list form as given in the attached sheet. I will be thankful for any help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Conversion of table into list

    Hi,

    in A12 and down


    Please Login or Register  to view this content.

    in B12

    Please Login or Register  to view this content.

    Hope it helps
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Conversion of table into list

    Hi,

    see the attached file.

    If you have to deal with many numbers, a pivot table could be helpful to do the trick.


    Cheers
    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)

Similar Threads

  1. Table Conversion
    By lordy16 in forum Excel General
    Replies: 2
    Last Post: 09-19-2013, 03:13 AM
  2. Macro Help: Table Conversion
    By JohnTait31490 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2010, 07:01 PM
  3. rates table vba conversion
    By devplan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2009, 07:37 PM
  4. Modify excel table for import in SQL (Table conversion)
    By badstef in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2008, 03:22 AM
  5. [SOLVED] hex conversion table
    By TStites in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2005, 08:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1