Rows to Columns (transpose ?)

[David_Little]

Hi all,

I feel this is super simple...

How to a turn this example dataset:

Into this:

Essentially turning the "quarter" fields into their own columns.

Thanks in advance!

[Christina_H · Accepted solution]

Here's what you need to do:

[Raj · Accepted solution]

You can use this as solution

[David_Little]

Just to add - Some of the amount and target fields may contain null values (in case of any sum issues)

[caltang]

Perhaps you can screenshot or provide the workflow? 

If they're null values, use a data cleanse tool to replace them with 0 if they're meant to be 0. Then sum will not be an issue.

However, if null values are not meant to be null, then it is better to provide some raw data for the community to work it out with you better.

[David_Little]

Hey @Christina_H Thanks ! - Is there a way to dynamically rename all of the columns without the underscore ?

[Christina_H]

@David_Little I almost included that!  Yes, just use a dynamic rename tool, Replace([_CurrentField_],"_"," ")