0
good. I have an excel file that presents information below. i intend to extract some information and assemble a single table with the following columns:
the original file, it breaks the information every 11 lines... the idea would be to check the field name and select the information in the cell next to or below depending on the position of the information and switch to the bottom row of the new table. can do ?
Friend ever tried to do something? I suggest to write a macro doing what you want with the first data block. From there, you could make a loop, to search for the term "Definitive", and run your macro again. Of course you will have to adapt there to the data, but if you try to post the code here and you will have more chances to receive help from the community.
– Evert
Thanks @Evert, I’m already doing that... :)
– user26858
Hello @Pedro, how are you doing? Any progress? Managed to achieve the desired?
– Evert