Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sort a column with repeated values based on another column

Hi there. For my requirement, I've got a specific layout for a report. To simplify, the series of Categories should present the Areas in a particular order (financial information).     Ev...
Need Help
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    I have a trick to avoid this error.

    You could import the data whose category is "A" at first. Then import other data and you will have two queries.

    Sort your first table based on another column, then append these two tables ( not as new ). 

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

I have a trick to avoid this error.

You could import the data whose category is "A" at first. Then import other data and you will have two queries.

Sort your first table based on another column, then append these two tables ( not as new ).