[Update] This conference is no longer available.
Excel Resources
For information on other Excel Resources, such as tips and tutorials, Excel videos, and online courses, see the following pages on my Contextures website.
Excel Help – Online Resource List
Other Online Excel Resources
List of online Excel help forums and other resources where you can ask questions or find answers
There’s a wealth of Excel information on the Microsoft web site
List of resources if you need help with Power BI questions and problems
Links to Microsoft Support Pages on Excel Topics
Great reference – Excel Function Bible (free) by Norman Harker and Ron de Bruin
_____________________
It’d mean an international trip, as I’d be crossing the Atlantic (from the west coast of Ireland to the East Coast of USA)
Ah, well maybe Jon and Bob could organize a conference on your side of the Atlantic, sometime in the future.
Hi All
I am currently working on two huge data spread sheets. My requirements is that based on the common unique column which is available in both the spread sheets I need to pull multiple records from multiple columns from spreadsheet one and insert and append to the end of the column in spread sheet two. Any valuable suggestions
==================================================================================
Spreadsheet 1:
StudentNumber Semester English Maths Science Computer Biology
10001 I B B A A C
10001 II A A A A B
10001 III B A A B B
10001 IV A A A A C
10002 I B B A A C
10002 II A A A A B
10002 III B A A B B
10002 IV A A A A C
10003 I B B A A C
10003 II A A A A B
10003 III B A A B B
10003 IV A A A A C
=========================================================================
Spredsheet 2:
StudentNumber First Name Last Name Grade DOB
10001 Mark Good 8 10/12/2001
10002 Jame Hary 8 11/03/2001
10003 Ben Handy 8 3/09/2001
=========================================================================
StudentNumber First Name Last Name Grade DOB Semester English Maths Science Computer Biology
10001 Mark Good 8 10/12/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
10002 Jame Hary 8 11/03/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
10003 Ben Handy 8 3/09/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
=========================================================================================================
Any valuable suggestions and fast approach to achieve this
Look Forward
Thanks
Murali