Return entire row starting with Non-Zero Cell

[acehit]

Hi All,

Trying to do something that's a bit tricky. I currently have two worksheets and am trying to pull in an entire row from one of them. The row pulled in would be based on a criteria that is shared on both worksheets (unique identifier). These are located in the left most column on their respective worksheets. Here's the tricky part. I'd like the row to start with the first non-zero value. I've tried several array formulas but all have not worked. Here's the set up of the raw data, the target worksheet, and the desired end result. Any help would be appreciated.

Source Worksheet
1.PNG

Target Worksheet
2.PNG

Desired End Result
3.PNG

[vlady]

Welcome to the forum, nice to have you with us.

Can you upload a real workbook since other members who would like to help can not open pictures due to firewall restrictions, etc.

To attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards,
Vlady

[acehit]

Thanks Vlady. Here's the workbook attached below.

Sample Data.xlsx