Very similar to this, and I would comment to ask @marc-pincince but I don't have the reputation require.
Would this be adaptable for 3 columns of data? I have column A, B, C.
- A = ID
- B = Award
- C = Year
What I need is to have new column A which groups all the ID's and then new column B which shows Award Year, Award Year, Award Year, Award Year , etc..
I tried using The Custom Column using =[AllData][Award][Year]
Also tried using =[AllData]([Award]+[Year])
Both of these result in errors. I was able to get [AllData][Award]
and [AllData][Year]
to work seperately.
Do you have any ideas?
Thanks, Jake