Copying a list without blanks

[bsift]

Hello,

I've been so close to figuring this out several times, but can't quite get it to work as I envision. Here's the premise:
Column A has labels, Column B has data
Not all rows have data so it would look like this:

Label A : Data A
Label B:
Label C: Data C
Label D: Data D
Label E:

Etc...

I need a copy of column A and B together (Label A: Data A) available for copy/paste, but omitting blank rows resulting in:
Label A: Data A
Label C: Data C
Label D: Data D

I've built an indexed array, but because I have a formula joining Label and Data, it doesn't recognize the blank lines.
Nor could I find the correct script to ONLY copy until the first blank value.
I've tried advanced filters without success.
Ideally I need this tied to a macro or a button to just copy the valid range to keep it simple for my audience that will be using this consistently.

Any help is appreciated!

[RChad]

Hi try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jolivanes]

It assumes that the empty cells in Column B are indeed blank.
Change references as required.

Please Login or Register  to view this content.

[sintek]

Why not simply...Or are we missing something?

Please Login or Register  to view this content.

[bsift]

That worked! Thanks RChad!