Forum Discussion

DenisL's avatar
DenisL
Copper Contributor
Oct 02, 2019
Solved

Sorting problem with imported data from query

Hello!   I have difficulties sorting the data in Excel. In the attached picture, there are 2 columns to the left and 2 to the right.  The ones to the left are imported via a query from an SQL serv...
excel
Formulas and Functions
Query
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 02, 2019

    DenisL 

    Table returned by Power Query and manually added columns are not synced. You may link them by some field, if exists, e.g. Task ID. Or move your calculations into Power Query - it looks like column Time Left could be added within Power Query and returned to Excel together with main table.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 02, 2019

DenisL 

Table returned by Power Query and manually added columns are not synced. You may link them by some field, if exists, e.g. Task ID. Or move your calculations into Power Query - it looks like column Time Left could be added within Power Query and returned to Excel together with main table.

DenisL's avatar
DenisL
Copper Contributor
Oct 02, 2019

Hello Sergei!

 

Thank you for the answer.

I do have a column to use as linkage. I am just not sure how to do that. Do you have a tutoria link at hand that I could maybe use? 

 

I will try the 2nd solution as well and see how far I can get with it.

Thanks again!

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 02, 2019

    DenisL 

    Second option with Power Query is much more preferable. If with ID you may add values from one table into another using INDEX/MATCH or VLOOKUP based on ID.

    • DenisL's avatar
      DenisL
      Copper Contributor
      Oct 02, 2019

      SergeiBaklan 

      The 2nd solution works amazingly! Thank you! I have almost finished my whole data set.

Resources