Results 1 to 2 of 2

Thread: combine multiple columns keeping some columns static

  1. #1

    combine multiple columns keeping some columns static



    Register for a FREE account, and/
    or Log in to avoid these ads!

    This is a sample of the data I have


    I would like to have my data like this - Image titled target file


    Please let me know how this can be done with or without macros.

    Source data


    Staffname Empname EmpID Project1 Domain Subdomain Project2 Domain Subdomain
    A AX 1 WER WERD WERS PQR PQRS PQRA
    B BA 2 VAR VARD VARS EWR EWRS EWRA


    Target data


    Staffname Empname EmpID Projects Domain Subdomain
    A AX 1 WER WERD WERS
    A AX 1 PQR PQRS PQRA
    B BA 2 VAR VARD VARS
    B BA 2 EWR EWRS EWRA

  2. #2
    Excel 2010, Tables
    De-Normalize Database
    A generic example.
    To adapt macro to your application and to be able to maintain it,
    a high level of VBA expertise is required.
    http://www.mediafire.com/download/au.../10_13_13.xlsm

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •