Previously, I had marked my solution in this question below.
What I was trying to do was extract data from files and put it in a table. There is a sample data file here: Sample1.xlsx
Original Table View:
Original Solution File:
Now the thing is I am trying to add a field called Supplier Name. In the data files where the data is taken from, it will always be in cell D1.
The new data table I am trying to create:
For now, I have also contacted the expert who provided me the original solution.
Any help is much appreciated! :)