T

#### Thomas Toth

I'm trying to get a second table which contains all elements of each

column of the first one, except that the empty-string-output cells ("")

are removed, but one. The first table should remain, the second one can

be either calculated or copied in some way.

I have a formula in every cell which calculates a value. If the result

is not valid, the formula will output "" (empty string). Due to my data

structure there are many empty-string cells between two blocks of values

in each column. I would like to remove all of them, except one, such

that the two blocks are separated by one empty cell in each column.

Empty is ok, I don't need the values/formulas, it is the final output table.

My original table contains the names across, and alpha-numerical values

down the column, with possible "" from formulas inbetween. Like this:

Table1 (what I have):

Name1 Name2 Name3 Name4

E123 E2343 "" E3432

E354 "" "" F3437

N324 "" "" N54323

E634 "" "" ""

"" "" "" ""

"" "" "" ""

"" "" "" ""

I4325 N6377 N3245 G2307

E6543 E5233 "" N29374

N987 N4353 "" ""

G8377 "" "" ""

"" "" "" ""

Table2 (what I need):

Name1 Name2 Name3 Name4

E123 E2343 -- E3432

E354 -- N3245 F3437

N324 N6377 N54323

E634 E5233 --

-- N4353 G2307

I4325 N29374

E6543

N987

G8377

where -- represents a blank/empty cell.

I tried copying and pasting with removing blanks but that doesn't work

as they are considered non-empty because of the formulas, even if I tick

to only paste the values. Copy-paste with a filter won't work as there

isn't enough space left on the sheet, and it would become impractical to

use. Besides, I think I tried that too. VBA is not an option either.

Any ideas how I could get the second table?

Thanks for any help,

Thomas