Forum Discussion

tking's avatar
tking
Regular Visitor
6 years ago

Transforming one large column into multiple distinct columns based on a third column

Hey I've ran into a situation where I need to pivot a grouping column and the relevant data should be grouped based on that. I'm trying to group display value by row number but it's not working as I...
Need Help
tking's avatar
tking
Regular Visitor
6 years ago

Hey ImkeF 

Something like this based on the initial data

 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tking 

my solution keeps the nulls as you've requested.

Much of it can be done through the UI:

- Check column "Row Number"

- Group and select "All" at "Operations"

- Tweak the resulting code by adding the ColumnName in square brackets

 

I'm afraid I cannot think of a simpler solution here.