Hi,
I am working on a report where I need to split the rows and update put it on a different column. For e.g.
Policy No DriverName
123 John
123 David
124 Matt
125 Phil
125 Peter
I need to split the data as per the policy number and instead of having driver names in different rows they need to be updated in different columns, So they should look like
Policy No Drivername1 Drivername2
123 John David
124 Matt
125 Phil Peter
Is this possible? Any help would be appreciated.