Compressing a List Into Consecutive Rows

[Twinky]

Does anyone have an idea how to make this happen?:

Sheet 2 has an extended list of codes in column C. Column D is where values are entered when needed. Some rows might get values entered and some may not.

On sheet 1, I need to compile a list showing the codes and their corresponding values. However, I need the list on sheet 1 to be in successive rows. That is, the list on sheet 1 would display the first value with a code, from sheet 2, show up in row 1 and the next value with a code would show up in row 2, the next in row 3 etc. etc.

So if sheet 2 has a value in D1, and it’s corresponding code in C1, and the next code & value pair is down is in C9/D9, how would the row 1 on sheet 1 detect and display the C1/D1 code & value pair on sheet 2 and then have the C9/D9 pair show in row 2?

I've attached two images that mock-up what I'm describing.

Big thanks to anyone who can chime in!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[shift-del]

Hello Twinky

You do not need a second sheet. Just use the filter.

 

[Fluff]

How about

=FILTER(Sheet2!C1:D1000,Sheet2!D1:D1000<>"")

 

[Twinky]

Hello Twinky

You do not need a second sheet. Just use the filter.

Thanks for the response Shift-Del

How about

=FILTER(Sheet2!C1:D1000,Sheet2!D1:D1000<>"")

That worked great! Thanks Fluff!

 

[Fluff]

Glad we could help & thanks for the feedback.