Growlithe
12-20-2018, 08:28 AM
I have this formula for combining many files from Excel (many files and 2-3 sheets):
https://pastebin.com/aZipQSNY
I already have the fact that it detects the same sheets and connects them but does not do it right, i.e. the data is mixed up as in 1 file in A1 the cell is empty and in A2 it overwrites the information from A1 to A2.
And I want it to look like this:
For example:
File 1
A1 = empty value
A2 = sun
A3 = empty value
File 2
A1 = 2
A2 = empty value
A3 = empty value
File 3
A1 = 2
A2 = empty value
A3 = excel
File 4 connected sheets
A1 = 2
A2 = sun
A3 = excel
https://pastebin.com/aZipQSNY
I already have the fact that it detects the same sheets and connects them but does not do it right, i.e. the data is mixed up as in 1 file in A1 the cell is empty and in A2 it overwrites the information from A1 to A2.
And I want it to look like this:
For example:
File 1
A1 = empty value
A2 = sun
A3 = empty value
File 2
A1 = 2
A2 = empty value
A3 = empty value
File 3
A1 = 2
A2 = empty value
A3 = excel
File 4 connected sheets
A1 = 2
A2 = sun
A3 = excel