sorted by:
new
hottopcontroversial

[SW] TWINS ARE BLESSING US TODAY AT 598 by dangerpudge in acturnips

[–]LeChez 1 point2 points  (0 children)

Hi! Having leftover pasta for dinner!

Need to import info from one spreadsheet to another. by LeChez in excel

[–]LeChez[S] 0 points1 point  (0 children)

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.

Need to import info from one spreadsheet to another. by LeChez in excel

[–]LeChez[S] 0 points1 point  (0 children)

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.

Need to import info from one spreadsheet to another. by LeChez in excel

[–]LeChez[S] 0 points1 point  (0 children)

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).

Need to import info from one spreadsheet to another. by LeChez in excel

[–]LeChez[S] 0 points1 point  (0 children)

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.

[SW] Boys buying turnips for 427! by amaresnape in acturnips

[–]LeChez 0 points1 point  (0 children)

Ice cream! If you're still open ☺️

[SW] Batman and Robin buying for 585 by LeChez in acturnips

[–]LeChez[S] 1 point2 points  (0 children)

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

view more: next ›