Profile cover photo
Profile photo
Gerardo Racine
Gerardo's posts

Post has attachment

Post has shared content
Pretty cool!
Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1
Download File:
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?

Post has shared content
                                       golden ratio

Post has shared content
Encontré tu próximo auto +Genoveva Gonzalez​
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
Mercedes Benz C63 AMG S Edition 1
9 Photos - View album

Post has shared content
Tonight on Independent Lens, “American Denial” investigates the unconscious attitudes that continue to dominate racial dynamics in American life.

Post has shared content
Me lo perdi anoche, todo por estar dormido, caramba. +Genoveva Gonzalez 
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:
#perseidmeteorshower   #perseids2014   #timelapse  

Post has shared content

Protea Awesome.

I say it's about time for me to get intimate with some flora. 

Post has attachment
Ya no hacen musica asi, que lastima.
Wait while more posts are being loaded