hozirontial to vertical copy of formula

[beancounter]

This question has plagued me for years and I have to ask. I have data (labels) going horizontal across the page. I want to re-display those labels vertically on another tab using concatenate formula.

How can I copy the formula that is looking at column A have it look at column B for the next row?

Example:
From:
A B C
1 X Y Z
2 X Y Z

To:
A
1 XX
2 YY
3 ZZ

Knowing how to do this sure would save time rather than changing each formula.

Thanks,

John

 

[adept]

I use the Edit >Paste Special and choose the Transpose
Will that work for you?

 

[beancounter]

I'll give it a try tomorrow and let you know

Thanks,
John