Forum Discussion

analysiswithtec's avatar
analysiswithtec
New Member
6 years ago
Solved

Concatenate rows and create headers

  2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019   Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec   Actual Actual Actual Actual Actual Actua...
Need Help
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi analysiswithtec 

     

    Please see the attached file with all the steps included.

     

    Personally I would skip the last two steps "Unpivoted Columns"  and "Merged Columns" as its easier to work with this format but I'm sure that you have valid reasons.

     

    Best Regards,
    Mariusz
     
    If this post helps, then please consider Accepting it as the solution.
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi analysiswithtec 

 

Please see the attached file with all the steps included.

 

Personally I would skip the last two steps "Unpivoted Columns"  and "Merged Columns" as its easier to work with this format but I'm sure that you have valid reasons.

 

Best Regards,
Mariusz
 
If this post helps, then please consider Accepting it as the solution.