Ask Your Question
0

Merge two colums in two sheets

asked 2015-07-28 18:56:38 +0100

Olumide gravatar image

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
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-07-30 14:51:23 +0100

pierre-yves samyn gravatar image

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:

screenshot

  • Click Ok, that's it

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-07-28 18:56:38 +0100

Seen: 251 times

Last updated: Jul 30 '15