Data rearranging problem

Question

While importing data from a dynamic query, refreshing the data shuffles their rows with one another. How can I stop that so that there's only updation of value and nothing else?Thanks

riny_van_eekelen · Answer

oshin7695&nbsp;A query refresh loads data back to Excel, precisely how you have set it up. If you then manually sort the table in a different way or when you add some columns manually, &nbsp;the sorting will be reset with the next refresh and extra columns will no longer by in-sync with the rest of the data. What exactly are you trying to do? Can you upload a few screenshots or share a file via Onedrive, Dropbox or similar?

oshin7695 · Answer

Hello,&nbsp;Riny_van_Eekelen,This is cryptocurrency data I want to store via API from two different exchanges (Binance and WazirX in Sheet 1 and Sheet 2 respectively). Then, I made a new worksheet to compare the prices between both. I used a formula to get the values of particular cryptocurrencies from the previous two worksheets. But due to the rearrangement of the rows of cryptos in the first two worksheets, the formula throws errors and wrong values. How can I freeze the rows to the cryptocurrencies so they don't shuffle between themselves?Thank You

oshin7695 · Answer

https://1drv.ms/x/s!AgWCg3cH9jLggZ9nK8bgCMskAaYahA?e=I8WcKh

riny_van_eekelen · Answer

oshin7695&nbsp;Thanks for sharing the file. Don't think that will ever work. You just linked every cell in the "Combined" sheet to selected cells in the PQ generated tables.&nbsp;You'll need a table connecting the two and do the calculations in PQ or perhaps with a pivot table. I started something in the attached file, but don't really understand what you are doing. Perhaps it can get you started. If not, I'm afraid I can't help you any further.&nbsp;&nbsp;&nbsp;

oshin7695 · Answer

Thank you,&nbsp;Riny_van_Eekelen. Your suggestions helped me.

Forum Discussion

Data rearranging problem

5 Replies

Resources