Forum Discussion

samsonobolade's avatar
samsonobolade
Frequent Visitor
7 years ago
Solved

How to join column when dates are spread out in columns

Hi there, I have a piece of project I’m currently doing. Unfortunately the date on the table is as follows: Company name|Jan2018| Feb2018 |etc ABC. |357 |467 | XYZ |456 |684 | How can I change ...
  • Ashish_Mathur's avatar
    7 years ago

    Hi,

    In the Query Editor, right click on the first column's heading and select "Unpivot Other columns".

    Hope this helps.