Results 1 to 5 of 5

TRANSPOSE OR NOT TO TRANSPOSE? How to change my table to a list format?

Threaded View

JuNova TRANSPOSE OR NOT TO... 08-10-2018, 01:00 PM
dflak Re: TRANSPOSE OR NOT TO... 08-10-2018, 01:47 PM
Pete_UK Re: TRANSPOSE OR NOT TO... 08-10-2018, 01:48 PM
JuNova Re: TRANSPOSE OR NOT TO... 08-14-2018, 06:33 AM
JeteMc Re: TRANSPOSE OR NOT TO... 08-21-2018, 09:24 AM
  1. 08-10-2018, 01:00 PM #1
    JuNova is offline
    Registered User
    Join Date
    02-15-2016
    Location
    London, UK
    MS-Off Ver
    14
    Posts
    32

    Unhappy TRANSPOSE OR NOT TO TRANSPOSE? How to change my table to a list format?

    Hello,

    I have a table with a matrix: rows showing Region, Country, Group and number of product for each country. Product and product code are in columns.
    I need to change it to a list view.

    Please see attached excel: the ORIGINAL tab shows how the data looks now and the NEW Tab how the new list view should look like.

    Please help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transforming table to desire format using Query Editor (merge cell, transpose etc)
    By jp16 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 06-07-2018, 04:26 AM
  2. [SOLVED] How to convert or transpose list into table?
    By effluvium in forum Excel General
    Replies: 9
    Last Post: 03-27-2016, 05:38 AM
  3. how to change value table in column to row (transpose)
    By herukuncahyono in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-25-2015, 05:05 PM
  4. transpose column to a range calculate and transpose to new table loop
    By moshro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2015, 10:52 AM
  5. transpose column in to table format
    By rojy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2012, 03:39 AM
  6. [SOLVED] Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item
    By cocolete in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2012, 10:01 AM
  7. TRANSPOSE ROWS INTO COLUMS without useing PASTE SPECIAL; TRANSPOSE
    By annepopa in forum Excel General
    Replies: 2
    Last Post: 02-19-2007, 04:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1