Hi, I have a this data set that does not associate as well with previous solutions this great community previously solved for me. I can't seem to combine the Cross Tabs needed to resolve. I have this for my data: vinrprDtStoreLbrCdReprOrderTot_Hrs_pd_forVIN123 2016-09-30AX12EABC1.81232016-09-30AX12MABC1.81232016-09-30AX12AABC1.87892016-11-07GG22ADEF1.97892016-11-08GG22EDEF1.97892016-11-09ZZ33NXYZ1.9 This is the desired output, with Concatenating Repair Order to Labor Cd: vinRprDt1RprDt2RprDt3Store1Store2Store3RprOrd_LbrCd1RprOrd_LbrCd2RprOrd_LbrCd3Tot_Hrs_Pd_ForVIN1232016-09-302016-09-302016-09-30AX12AX12AX12ABC_EABC_MABC_A1.87892016-11-072016-11-082016-11-09GG22GG22ZZ33DEF_ADEF_EZYZ_M1.9

Transforming or Transposing

Hi,

I have a this data set that does not associate as well with previous solutions this great community previously solved for me. I can't seem to combine the Cross Tabs needed to resolve.

I have this for my data:

vin	rprDt	Store	LbrCd	ReprOrder	Tot_Hrs_pd_forVIN
123	2016-09-30	AX12	E	ABC	1.8
123	2016-09-30	AX12	M	ABC	1.8
123	2016-09-30	AX12	A	ABC	1.8
789	2016-11-07	GG22	A	DEF	1.9
789	2016-11-08	GG22	E	DEF	1.9
789	2016-11-09	ZZ33	N	XYZ	1.9

This is the desired output, with Concatenating Repair Order to Labor Cd:

vin	RprDt1	RprDt2	RprDt3	Store1	Store2	Store3	RprOrd_LbrCd1	RprOrd_LbrCd2	RprOrd_LbrCd3	Tot_Hrs_Pd_ForVIN
123	2016-09-30	2016-09-30	2016-09-30	AX12	AX12	AX12	ABC_E	ABC_M	ABC_A	1.8
789	2016-11-07	2016-11-08	2016-11-09	GG22	GG22	ZZ33	DEF_A	DEF_E	ZYZ_M	1.9

Tips and Tricks

Preparation

Accepted answers

mborriero

@LincolnMike, try this please and let me know if you can open it.

@andre347 I like the way how you can achieve the same results in different way. However you forgot to concatenate reporder and LbrCD. I have decided to implement a dynamic solution, in this case If new fields will be added to the database, you will not need to review your workflow.