Converting formula to text - UPDATE

[Jay]

What I am actually trying to do is to find an effective
and easy way of reading values that are in adjacent
columns and displaying them one below the other.

Here is the deal:
In one spreadsheet, I have values in columns A through C.
I have a total of 50 rows with several blank rows in
between.

Sheet 1:
Col A Col B Col C
23 X P1

54 Y Q1

534 Z R1

32 X S1
43 Y T1

I have another sheet in which I want to list the values
from each column (without including blank rows and some
unwanted rows). So I started with the first column (A) and
started referencing only the rows that I wanted.

What I am now trying to do is somehow try and read the row
numbers that were referenced along with the new column to
list the values from the subsequent columns.

So Sheet 2 should look like this:

Sheet 2:
Col A
23

54

534

32
43

X

Y

Z

X
Y

P1

Q1

R1

S1
T1


If there is a better way to do this, please let me know.

Thanks,
Jay

 

[Jim Rech]

Once you have your formulas for column A entered you can copy them to
columns B and C to create formulas that reference the other two columns.
Then you can Cut and Paste the column B formulas below the column A
formulas. And then do the same for the column C formulas, putting them
below the column B formulas. (If I understand what you want).