combining data a different way (sort of like appending)



  • Joel Stewart

    The way I would do this is to add the extra columns (with empty results) into each of the sources and then use a UNION function to bring the two data sets together into a single sheet. 

    In your example, I'd specifically add columns X and Z to Report 1 and columns D and E to Report 2 then perform the union on those results. 

    Hope this helps! 

    Comment actions Permalink
  • n

    yikes OK look like I have to manually add 50+ the extra columns then 

    Comment actions Permalink

Please sign in to leave a comment.