+ Reply to Thread
Results 1 to 4 of 4

Combining 2 x columns of compatable data into 1 x column

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    newcastle
    MS-Off Ver
    Excel 365
    Posts
    56

    Combining 2 x columns of compatable data into 1 x column

    Good morning,

    I am new to using Power Pivot (Excel 2016).

    I have 3 Columns of data, an 'ID', an 'Age_class' and an 'Age_range' in a table

    Capture.JPG

    Capture 2.JPG

    I need to combine the 'Age_class' and an 'Age_range' into 1 x column called 'Age'

    Is this possible in power pivot please?

    Many thanks
    Phil
    Attached Files Attached Files
    Last edited by sa1ntj0hn; 11-28-2017 at 08:51 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Combining 2 x columns of compatable data into 1 x column

    Why PowerPivot if you've built-in PowerQuery?

  3. #3
    Registered User
    Join Date
    01-20-2009
    Location
    newcastle
    MS-Off Ver
    Excel 365
    Posts
    56

    Re: Combining 2 x columns of compatable data into 1 x column

    Hi sandy,

    Thanks for pointing me in the right direction.
    Many thanks
    Phil

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combining 2 x columns of compatable data into 1 x column

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

    If you did it already - ignore it.
    Thank you.

+ 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. Combining multiple columns data into a single column
    By tmor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2016, 07:12 PM
  2. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  3. Replies: 3
    Last Post: 04-28-2014, 02:24 PM
  4. Replies: 1
    Last Post: 11-05-2012, 12:52 AM
  5. [SOLVED] Combining multiple columns of data into single column
    By dsklein85 in forum Excel General
    Replies: 6
    Last Post: 10-30-2012, 11:18 PM
  6. Combining data from three columns into a new column.
    By nns110 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2009, 04:09 PM
  7. Combining Data Columns / adding prefix to entire column
    By MC Advantages in forum Excel General
    Replies: 6
    Last Post: 01-15-2009, 03:22 PM

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