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
Bookmarks