+ Reply to Thread
Results 1 to 2 of 2

Change multiple variables respective column values in rows

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    5

    Change multiple variables respective column values in rows

    Hi Guys,

    Facing a big problem in an excel with 90k rows. I need to change the values in the respective columns and have them in the rows with a new column header

    Please help - thanks in advance.

    So my data looks like this below:

    Reporter Reporter Name Commodity Commodity Name Partner Units 2015 2016 2017 2018
    36 Australia Gold 20319 World KG 3181015 1818669 1754690 1699184
    37 Australia Gold 20319 APAC $ 8201485 7720708 7789696 11365406
    38 Gold Australia 20319 EU ID 18 17 16 47

    I need the table to look like this:

    Year Reporter Reporter Name Commodity Commodity Name Partner Kg $ ID
    2015 36 Gold Australia 20319 World 3181015 8201485 18
    2016 36 Gold Australia 20319 World 1818669 7720708 17

    and so on...

    Please Help!!

  2. #2
    Registered User
    Join Date
    08-29-2018
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Change multiple variables respective column values in rows

    You might be able to do so with Pivot Tables.
    Select all your columns, insert pivot table, then rearrange your data points to the appropriate columns and rows as desired.
    Then once it looks like what you want, you can copy the pivot table and paste as values only into another sheet for a cleaner look.

+ 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] Removing duplicates from column A while keeping their respective values from column B
    By joel.mugabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2016, 02:38 AM
  2. Replies: 5
    Last Post: 01-24-2016, 01:04 AM
  3. Find value with multiple variables and change value in other column
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2014, 05:36 AM
  4. Replies: 8
    Last Post: 04-11-2014, 10:18 AM
  5. Convert a single column with variables and values across many rows into Table form!
    By paul2014 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2014, 09:18 PM
  6. [SOLVED] VBA macro that hide and unhide column to respective rows based on first column value
    By janine6192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 06:21 PM
  7. Replies: 4
    Last Post: 03-22-2006, 10:50 AM

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