hello,
I have the following probem:
There are 10 excel files, each of them contains the same name of the data but different figures (e.x. C5 "number of products"; D6 "221"). All excel files are identical except numbers.
The aim is to create a data base where all number can be seen together. I organise the order of lines and the figures will transfer from each file one after one"
(e.x. A1 "number of products"; B1 "221", C1 "14".
It can be done manually, but there are around 200 fields which are in wrong order.
Is there a solution for that???
Bookmarks