Copy cells after unmerging

lake1069

New Member
Joined
Mar 2, 2023
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Book1
ABCDEFG
1KeyReview IDFolder Transition AtFrom Folder To Folder Review Classification Folder Transition User Name
2B2BJP2M6116402013/6/2023 3:56:04 PMNew - Portal CreatedEssentialPharmacyNot Found
33/6/2023 4:00:48 PMEssentialPharmacistPharmacy0
43/6/2023 4:07:26 PMPharmacistURGENT Outreach 1Pharmacy0
53/7/2023 9:49:44 AMURGENT Outreach 1URGENT Outreach 2Pharmacy0
63/8/2023 8:53:13 AMURGENT Outreach 2URGENT Outreach 3Pharmacy0
7B2BPXKWC116347583/3/2023 4:24:02 PMNew - Portal CreatedEssentialPharmacyDenied
83/3/2023 4:32:14 PMEssentialPharmacist ACAPharmacy0
93/6/2023 10:10:47 AMPharmacist ACACallbackPharmacy0
103/6/2023 11:01:43 AMCallbackACA NotificationsPharmacy0
113/6/2023 12:42:56 PMACA NotificationsClosedPharmacy0
12B2BQHGWH116438973/7/2023 12:14:24 PMNew - Portal CreatedEssentialPharmacyNot Found
133/7/2023 12:48:47 PMEssentialPharmacistPharmacy0
Sheet1
Cell Formulas
RangeFormula
G2:G13G2=XLOOKUP(A2,'[BCBSNC - Custom - Closed Request Productivity (4).csv]BCBSNC - Custom - Closed Reques'!$D:$D,'[BCBSNC - Custom - Closed Request Productivity (4).csv]BCBSNC - Custom - Closed Reques'!$AB:$AB,"Not Found",0)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Hello All - Column A groups several different rows via merge. I need to break up the merge and get the "key #" to fill in the new empty rows

for example, after unmerged i need it to display like this. I've tried every trick i know. anyone have any idea how to do this? i can do it manually as there are thousands of rows

KeyReview IDFolder Transition AtFrom Folder To Folder Review Classification Folder Transition User Name
B2BJP2M6116402013/6/2023 3:56:04 PMNew - Portal CreatedEssentialPharmacyNot Found
B2BJP2M73/6/2023 4:00:48 PMEssentialPharmacistPharmacyNot Found
B2BJP2M83/6/2023 4:07:26 PMPharmacistURGENT Outreach 1PharmacyNot Found
B2BJP2M93/7/2023 9:49:44 AMURGENT Outreach 1URGENT Outreach 2PharmacyNot Found
B2BJP2M103/8/2023 8:53:13 AMURGENT Outreach 2URGENT Outreach 3PharmacyNot Found
B2BPXKWC116347583/3/2023 4:24:02 PMNew - Portal CreatedEssentialPharmacyDenied
B2BPXKWC3/3/2023 4:32:14 PMEssentialPharmacist ACAPharmacyDenied
B2BPXKWC3/6/2023 10:10:47 AMPharmacist ACACallbackPharmacyDenied
B2BPXKWC3/6/2023 11:01:43 AMCallbackACA NotificationsPharmacyDenied
B2BPXKWC3/6/2023 12:42:56 PMACA NotificationsClosedPharmacyDenied
B2BQHGWH116438973/7/2023 12:14:24 PMNew - Portal CreatedEssentialPharmacyNot Found
B2BQHGWH3/7/2023 12:48:47 PMEssentialPharmacistPharmacyNot Found


I know i can unmerge column A to get rid of the merge but then I am stuck usin
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top