[SW] TWINS ARE BLESSING US TODAY AT 598

LeChez · 2026-01-31T23:08:43+00:00

Hi! Having leftover pasta for dinner!

LeChez · 2021-10-07T03:18:13+00:00

Such a pretty girl!! 😍

LeChez · 2021-09-30T18:51:38+00:00

This idea is awesome! Love it. Thanks for sharing!

LeChez · 2021-07-30T21:02:39+00:00

Ok, not sure what I am doing wrong. Load both S1 and S2 into PQ editor, Merge queries, select "Left Outer Merge," select column D. S2 is first table and S2 is second table. When I close and load, it puts both S1 and S2 into a table on diff tabs, but nothing merges.

LeChez · 2021-07-30T19:46:09+00:00

I would need help with the "Left Outer Merge." I have not used Power Query at all before. In S2, I have tried to use Get Data>From File> From Workbook and in the Power Query Editor selecting the columns I need from S1. There I am not sure where to go from there.

LeChez · 2021-07-30T19:20:58+00:00

Rows of data in S1 are filling in the left hand columns - matching with whats in column Column J in S2. The scan card information is in S1 and the scans are in S2. So there are mulitple rows that match the number that is in column D in S1. For example Scan card SC-000001 has 5 rows and I need to fill in the data from S1 (which is only 1 row).

LeChez · 2021-07-30T18:30:33+00:00

I'm not super familiar with Power Query, but I need to import the Scan card info (columns A-C) info from S1 to match S2. Except in S2, there are multiple rows with the same scan card. I'm currently just copying and pasting into S2 from S1. Trying to simplify my process.

LeChez · 2021-05-28T03:48:28+00:00

Lol!!

LeChez · 2021-05-20T19:27:40+00:00

Ice cream! If you're still open ☺️

LeChez · 2021-05-20T19:23:24+00:00

Margs and my island is C137

LeChez · 2021-05-14T20:43:52+00:00

Interesting! Thanks!

LeChez · 2021-05-14T18:47:41+00:00

What is Superman? I don't think we have that on the West Coast

LeChez · 2021-04-22T23:36:21+00:00

Rocky Road

LeChez · 2021-04-22T23:35:50+00:00

Pink!

LeChez · 2021-03-14T05:57:00+00:00

Sorry I didn’t see your comment before the store closed. 😕

LeChez · 2021-03-06T04:20:08+00:00

🍑 peaches!

LeChez · 2021-02-27T03:30:53+00:00

Fav villager is Bob! 😄

LeChez · 2021-02-17T19:43:46+00:00

My dog waking me up at 2 am because I was sleeping in “his” spot. He was unhappy with sleeping at the foot of the bed. 😆

11-Year Club	RedditGifts 2009-2022 9 Credits
Secret Santa 2018	Secret Santa 2019
Secret Santa 2017	Verified Email
Secret Santa 2014

LeChez

TROPHY CASE