beancounter
Board Regular
- Joined
- Oct 30, 2002
- Messages
- 111
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
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