Trying to Pivot Data with Multiple Columns/Data Values

[thenning]

Hello,

I have some data from a workflow that I'm trying to re-organize into a more user-friendly version. 

Here's how the data currently looks:

Org ID

Submission ID

Name

State

Measure

Rate

State Benchmark

SB Variance

National Benchmark

NB Variance

I'm trying to re-organize the data as follows:

Measure #1

Measure #1

Measure #1

Measure #1

Measure #1

Measure #2

Measure #2

Measure #2

Measure #2

Measure #2

Org ID

Submission ID

Name

State

Rate

State Benchmark

SB Variance

National Benchmark

NB Variance

Rate

State Benchmark

SB Variance

National Benchmark

NB Variance

I can't seem to use the CrossTab tool, because it only allows for 1 column/data value, so I'm wondering how best to accomplish this?  Any suggestions would be greatly appreciated.  Thanks!

Sincerely,

T.H.

[benakesh · Accepted solution]

Hi @thenning , 

Hope this helps