Forum Discussion

powerbiuser101's avatar
powerbiuser101
Advocate I
8 years ago
Solved

Append multiple columns in same table

Hello,

I have a table similar to below:

JanCount FebCount MarCount
01.01.20185 01.02.20188 01.03.201830
02.01.201820 02.02.201820 02.03.20182
03.01.201810 03.02.20181 03.03.201814
04.01.20183 04.02.201850 04.03.201833

 

Which I want to convert to:

MonthCount
01.01.20185
02.01.201820
03.01.201810
04.01.20183
01.02.20188
02.02.201820
03.02.20181
04.02.201850
01.03.201830
02.03.20182
03.03.201814
04.03.201833

 

I tried pivoting the columns but that only seems to work well for the dates. Not sure how else to proceed. Any help appreciated.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on 

     

    Then you would have 3 tables 

    Jan Count 

    Feb Count

    Mar Count 

     

    Here you can just do an append and have it all in 2 columns

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on 

     

    Then you would have 3 tables 

    Jan Count 

    Feb Count

    Mar Count 

     

    Here you can just do an append and have it all in 2 columns

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on 

     

    Then you would have 3 tables 

    Jan Count 

    Feb Count

    Mar Count 

     

    Here you can just do an append and have it all in 2 columns