I have made an workflow that until this point opens all excel files from a folder, iterates through all the files and copies only the headers in a separate “consolidated file” and pastes them all in one row starting from A1 cell (Example: A1, B1, C1, D1 and so on ).
Each file has mostly the same headers but each file will have at least 2, 3 different headers.
The expected number of files that need to be consolidated are above 50 or more
Now the next step that I want to do is to copy the contents that correspond to each file in that “consolidated file” but only copy the headers that are present in that specific file below their respective column (appended).
I have attached some files to better exemplify what I mean.
So basically my workflow until this point reads each file (" File 1; File 2 “) copies the headers from each file and pastes it in the file(” List of columns from File 1 and File 2 ").
And now I need to copy and paste the data in the file (“List of columns from File 1 and File 2”) as it’s shown in the file (" Expected result ")
Looking forward for a solution.
P.S I am quite new to UiPath so an example workflow for this particular case would be really appreciated.
Thanks a lot !