I need to combine data from two Excel sheets and I have found some good tutorials for using the Consolidate and Appending. These, however, do not seem to help in my case, which I try to explain in a simple manner:
- In one of the sheets, I would have 2 rows: cat and dog, and two columns: colour and size.
- In the second sheet I would have 3 rows: cat, dog and bird, and only one column: age.
Now I would like to make automatically a new sheet that would contain all the 3 animals on their (3) rows and their colour, size and age in 3 columns. Data concerning colour and size of the bird would naturally not be available in this merged table since the poor bird is not included in the first sheet.
Is there any way of doing this in a simple manner, without programming skills?
I should also mention that I found this discussion that seems to address a similar question: Merge Excel rows from two sheets. There is also a solution available, but as it requires some tweaking with the formula and the solution is already several years old, I thought to ask if the current Excel can do this in a more automated manner. Any help would be greatly appreciated.