Excell script for rearrange cells info
Budget: $10 – $30 USD
I have two tables:
- Table 1 is simply organized by rows and their IDs, sequentially;
- Table 2 is organized two by two, in rows. Left cell has numbers 1 or 0, and right cell has the IDs. They are then organized in rows.
Attached images may explain better.
I need to identify IDs from table 2 and insert 0 or 1 in left cell of their same ID in table 1, according to the referred 0 or 1 from table 2.
I need an libreoffice (or excell) script so I can do that. There are several tables with over than 60000 IDs( entries), so i just need the formula, better if works in libreoffice.
Low budget!
Thanks
- Table 1 is simply organized by rows and their IDs, sequentially;
- Table 2 is organized two by two, in rows. Left cell has numbers 1 or 0, and right cell has the IDs. They are then organized in rows.
Attached images may explain better.
I need to identify IDs from table 2 and insert 0 or 1 in left cell of their same ID in table 1, according to the referred 0 or 1 from table 2.
I need an libreoffice (or excell) script so I can do that. There are several tables with over than 60000 IDs( entries), so i just need the formula, better if works in libreoffice.
Low budget!
Thanks