How to add D-value after each 2 rows and transpose to columns ?

[ups366]

Dear all , hello !

I have to transpose a table, but first needed add difference below each 2 rows, please see the picture, maybe a easy way can do this result ? Thank you very much !

[MarqueeCrew · Accepted solution]

@ups366 ,

I first handle adding a 3rd row for each record set.  Then I calculate the results.  Now we must rename the columns so that after they crosstab, they don't get alphabetized.  Now we can rename the columns.

Hopefully you don't have duplicate www names.

Cheers,

Mark

[MichalM · Accepted solution]

@ups366 

Here's a bit more cumbersome approach

• Count the number of records and dynamically generate the number of pairs in your data set - number of records / 2
• Append these back to your original data set - join by record position
• Put the pair values in-line and create the new www and num values
• Union these back to your original data
• Sort the data and assign the values a record ID as the Cross Tab tool will order the columns by their name in ascending order

[ups366]

Hi, @MarqueeCrew 

Thank you for your reply ! I got it and rebuilding now ! 

Hi, @MichalM 

Thanks  a  lot !