This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 91%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E89%3C/text%3E%3C/svg%3E)
Sheet1 is a data group, and importing the merged cell values from Sheet1 as a drop-down list in Sheet2 will automatically display the subsequent columns of data
Any help would be greatly appreciated.
Sheet 1:
Sheet 2(Result):
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365 Pro Plus with Power Query.
Transform merged cells with PQ.
Select cells with DV and Defined Names.
https://www.mediafire.com/file_premium/qlxxicwm2o7t7fg/07_31_23.xlsx/file
https://www.mediafire.com/file_premium/yhigvjfyk6dsu54/07_31_23.pdf/file
Hi,
In cell E1, enter this formula
=FILTER(B1:B8,SCAN(0,A1:A8,LAMBDA(a,i,IF(i="",a,i)))=D1)
Hope this helps.