Results 1 to 4 of 4

Stacking multiple columns into one with duplication of other columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2018
    Location
    Copenhagen
    MS-Off Ver
    2013
    Posts
    2

    Stacking multiple columns into one with duplication of other columns

    Hi, I have a problem which I have tried to solve for some time but without success. Any help would be greatly appreciated!

    Basically, my problem is that I have several columns which should be merged into one. An example
    Row Column A Column B Column C Column D Column E
    1 wa wc 4 2
    2 wa 3 4
    3 wc wb wa 1 5

    In this example I want 6 rows. The first row should contain column A, D and E (with the column values of wa, 4, 2), second row column B (i.e. wc, 4,2) third row column A again (i.e. wa,3,4) fourth row column A (i.e. wc,1,5), fifth row column B (i.e. wb,1,5) sixth row column C (i.e. wa,1,5).

    I have attached a example of before/after transformation!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. stacking multiple columns into one
    By niktodorov1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2018, 01:18 PM
  2. [SOLVED] Stacking data from multiple columns.
    By paularthur90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2016, 05:15 AM
  3. Replies: 3
    Last Post: 11-14-2015, 03:48 PM
  4. Replies: 2
    Last Post: 04-09-2014, 03:05 PM
  5. Combining Multiple Columns without stacking
    By ATowne20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2013, 01:41 PM
  6. Stacking many columns into one
    By pickslides in forum Excel General
    Replies: 2
    Last Post: 01-08-2012, 08:04 PM
  7. Stacking columns across multiple sheets
    By mstinson23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2009, 03:08 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