Data Tansformation

Question

Hi Team,

Could you please assist on below mentioned query - Thanks in advance.

Orginal Data set :

IdDATEPrice121724611/14/202220.08121724611/13/202219.95121724611/10/202219.43121724611/9/202218.43121724611/8/202218.56121724611/7/202218.51121722511/14/202256.3121722511/13/202255.5121722511/10/202254121722511/9/202255.7121722511/8/202256.5121722511/7/202257.3121720211/14/202211.22121720211/13/202210.89121720211/10/202210.62121720211/9/202210.97121720211/8/202211.71121720211/7/202211.88

Required Solution :

id11/14/202211/13/202211/10/202211/9/202211/8/202211/7/2022121724620.0819.9519.4318.4318.5618.51121722556.355.55455.756.557.3121720211.2210.8910.6210.9711.7111.88

Question Tech.xlsx

ShankerV · Answer

Hi @Jaganmohan

You can achieve your solution in the below way.

Many thanks

Shanker V

DataNath · Answer

Here's how you can do this whilst easily maintaining the order of fields and rows:

As standard, Cross-Tab will cause fields to be sorted in alphabetical order and so we can get around this by just assigning an ascending integer to each which we then just swap out for the original header that corresponds to it when we come to the final few steps.

Cross tab dates to headers.yxmd

Felipe_Ribeir0 · Answer

Hi @Jaganmohan

One way of doing this

Data Tansformation.yxmd