Forum Discussion
Solved
CSV file----->> Excel Spread Sheet-Appended Sync
Hi, I am trying to maintain an excel spreadsheet using a data link from a CSV file. This is straightforward, BUT here's the challenge: I need the various rows to append when there is a change in th...
BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.
Example attached.
BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.
Example attached.
Riny_van_Eekelen thank you so much, this worked for me first time following your description.
Great Stuff!
Great Stuff!