I'm trying to get multiple tables to self reference to hold the information in place that I've manually added, somehow it's not working.
I've scanned the website and come on to another tread with the same issue, and a recent YouTube doing the same, but unfortunately no success.
Mr.Excel: Excel Power Query: self-referencing manually entered data
Youtube: Excel – Self Referencing - How to Merge a table to itself? (OE H-011 EN)
Anyone able to help me out.
I wish to self reference the tables on the Stocktake Tab.
Besides that, if you have any tips on speeding up the refresh rate or any suggestions for my build, please let me know, quite new at power query but happy to have made it work so far.
Link to file
I've scanned the website and come on to another tread with the same issue, and a recent YouTube doing the same, but unfortunately no success.
Mr.Excel: Excel Power Query: self-referencing manually entered data
Youtube: Excel – Self Referencing - How to Merge a table to itself? (OE H-011 EN)
Anyone able to help me out.
I wish to self reference the tables on the Stocktake Tab.
Besides that, if you have any tips on speeding up the refresh rate or any suggestions for my build, please let me know, quite new at power query but happy to have made it work so far.
Link to file