Profile

Cover photo
Gerardo Racine
Works at Marketscan
Attended ESTIC17 Lic. Emilio Portes Gil
Lives in Thousand Oaks, Ca USA
84,404 views
AboutPosts

Stream

Gerardo Racine

Shared publicly  - 
 
Pretty cool!
 
Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1
Download File: http://people.highline.edu/mgirvin/excelisfun.htm
Learn how to use Power Query transform 36 Lookup Tables Into 1 Lookup Table for VLOOKUP Formula.
1. (00:10) Introduction to problem we want to solve and look back to Excel Magic Trick 1231.
2. (00:13) Use Filter Feature to get 36 Tables into Power Query
3. (02:21) Name Query to we can use Name in VLOOKUP formula later.
4. (02:35) Use Split Columns feature with Two Delimiters (Colon and Space) to remove “Table” from Field Name and create the “Product” column.
5. (03:12) Use Split Columns feature with One Delimiter to Split “Region” and “Product Group” columns.
6. (03:32) Use Fill Down Feature to fill “Region” and “Product Group” throughout columns
7. (03:49) Filter out Nulls in Discount Column to remove unwanted records.
8. (04:22) Merge Columns into one Unique Identifier Column so VLOOKUP can have a first column that it can use to lookup the discount rate. See how to select the columns in the correct order so the Merge Columns feature merges in the correct order.
9. (05:25) Rename columns
10. (05:52) Close and Load to Excel as a Table.
11. (06:32) VLOOKUP with Joined lookup_value to get the correct discount rate from 36 tables.

Thanks to Bill Szysz at YouTube!!!!

Power Query to Transform Data.
Lookup with Multiple Tables.
What do I do if VLOOKUP has multiple tables?
How do I lookup when there are multiple tables?
View original post
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
 
                                       golden ratio
2 comments on original post
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
 
Tonight on Independent Lens, “American Denial” investigates the unconscious attitudes that continue to dominate racial dynamics in American life.
View original post
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
Me lo perdi anoche, todo por estar dormido, caramba. +Genoveva Gonzalez 
 ·  Translate
 
2014 Perseid Meteor Shower Peaks Tonight!
In honor of the 2014 Perseid Meteor shower peaking tonight, I offer you time-lapse clips from the 2010-2012 Perseids in the first 1:49 of this video.  All of the footage in it was compiled during my travels in recent years.  I hope that you enjoy it!
You can see more of my time-lapse videos on my YouTube channel here: http://www.youtube.com/user/JeffSullivanPhoto
#perseidmeteorshower   #perseids2014   #timelapse  
2
Genoveva Gonzalez's profile photo
 
Yo también, pero ya abra más , no te preocupes gerardo 
 ·  Translate
Add a comment...

Gerardo Racine

Shared publicly  - 
 
 

Protea Awesome.

I say it's about time for me to get intimate with some flora. 
1
Genoveva Gonzalez's profile photo
 
Nice , look a little like passion fruit . Beautiful flower !
Add a comment...

Gerardo Racine

Shared publicly  - 
1
Genoveva Gonzalez's profile photo
 
Everybody wants to rule the world ! I like it 
Add a comment...

Communities

5 communities

Gerardo Racine

commented on a video on YouTube.
Shared publicly  - 
 
45:00 Macaco mata el toro https://youtu.be/n2t6nY_nBXQ
 ·  Translate
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
Encontré tu próximo auto +Genoveva Gonzalez
 ·  Translate
 
If the thought the standard +Mercedes-Benz South Africa #w205 #c63amg was good enough, think again!

The mad scientists from #affalterbach have created an Edition 1 version of the #c63amgs model.

The 4.0L V8 twin-turbo will deliver 375kW and 700Nm, enough to get from 0-100kph in just 4.0 seconds!

Do you think it has enough in its arsenal to punish the +BMW South Africa #m3?

+Mercedes-AMG +Mercedes-Benz #mercedesbenz #fastcars #salooncars
1 comment on original post
1
Genoveva Gonzalez's profile photo
 
Absolutely that will be my next car , hopefully soon;)
Add a comment...

Gerardo Racine

commented on a video on YouTube.
Shared publicly  - 
 
i like it!
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
Ya no hacen musica asi, que lastima.
 ·  Translate
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
Loving it! 
1
Add a comment...

Gerardo Racine

Shared publicly  - 
 
Cruz Azul de Thousand Oaks Fall 2011
1
Add a comment...
People
Communities
5 communities
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Thousand Oaks, Ca USA
Links
Work
Occupation
Data analyst
Employment
  • Marketscan
    Data Analyst, present
Education
  • ESTIC17 Lic. Emilio Portes Gil
    1987
Basic Information
Gender
Male