Split data based on column value

[tanja90]

Hello,

In the attachment there is an example of data I have (sheet name: "old") and data how I want to split it (sheet name: "new").  How can I create it?

Thank you.

[DavidP · Accepted solution]

Hi @tanja90 

This can be done with reporting tools as shown below. The Render tool can create an excel output if you wish.

[Emil_Kos]

Hi @DavidP,

This is cool. I wasn't aware I can use summarize on table!

Thank you for sharing!

[atcodedog05]

I totally agree on that @Emil_Kos 

Thanks for this great new exposure 🙂 @DavidP