0
I have two spreadsheets in Excel.
In the first I have the following data, for example:
ID | NOME
-----|----------
100 | Luiz
101 | Pedro
102 | Aline
On the second spreadsheet, I have:
ID | CATEGORIA
-----|------------
100 | Livros
100 | Filmes
101 | Livros
101 | Games
101 | Móveis
102 | Filmes
That is, this second spreadsheet has Ids that repeat for each category. I would like to unite these two spreadsheets, so that it stays more or less like this:
ID | NOME | CATEGORIA
-----|-----------|-------------
100 | Luiz | Livros
100 | Luiz | Filmes
101 | Pedro | Livros
101 | Pedro | Games
101 | Pedro | Móveis
102 | Aline | Filmes
Is that a possibility? Thank you.
I will test here. In case, the two sheets have to be in the same file and in separate tabs or can be in separate files?
– Ricardo
They can be in separate files. No problem. You can even do in the same spreadsheet, but it is very messy. Do it in separate spreadsheets even
– igventurelli
By the way, this formula fills only one cell. After you type the formula press enter, then click again on that cell and a small black square will appear at the bottom right corner of the cell. Click, hold and drag down to fill the remaining cells.
– igventurelli
The cells are getting "#NAME?".
– Ricardo
Libreoffice.
– Ricardo
Send a print of your spreadsheets, please
– igventurelli