Concatenate rows and create headers

Question

2019

20192019201920192019201920192019201920192019

JanFebMarAprMayJunJulAugSepOctNovDec ActualActualActualActualActualActualActualActualActualActualActualForecast

Sales

100100100100100100100100100100100100

Cost-50-50-50-50-50-50-50-50-50-50-50-50

I have a data set that looks like the above.

I want to create header names that concatenate the three first rows and then unpivot the data, to get something like this:

2019-Jan-ActualSales1002019-Jan-ActualCost-502019-Feb-ActualSales1002019-Feb-ActualCost-502019-Mar-ActualSales1002019-Mar-ActualCost-50

If you could help that would be great. Thanks

fmvizcaino · Accepted Answer

Hi @analysiswithtech ,

Take a look at the attached example. I'm using group by to concatenate the rows based in recordID number and transposing as you need. The only thing left to do is to order your data properly.

Let me know if that works for you.

Best,

Fernando Vizcaino