Merge two colums in two sheets

[Olumide]

I’ve got two sheets. Sheet 1 contains, among items, two columns. The first lists the price rank

                  Price rank
Banana            1
Pear              2
Pineapple         3
Orange            4
Mango             5

Sheet 2 contains, again among other items, the same fruits listed in different order but this time a sugar content colum

                  Sugar content
Pineapple         1
Mango             2
Orange            3
Banana            4
Pear              5

Is it possible to produce a third sheet that merges both sets of columns like so (the order is irrelevant)

Pineapple         1    3
Mango             2    5
Orange            3    4
Banana            4    1
Pear              5	   2

[PYS]

Hi - Yes it is possible. If your data are in A1:B6 in Sheet1 & Sheet2:

• Click in Sheet3.A1,
• Menu Data Consolidate
• Click in the Source data ranges text box or use his Shrink button to select data from Sheet1, then click Add
• Do it again for Sheet2
• Unfold Options to check Row labels & Columns labels

Expected:

• Click Ok, that’s it

Regards