S
Sam via OfficeKB.com
Hi All,
How do I Index a Row of Text values in one Sheet and Return the Text data to
a NEW Sheet in one Column?
Sample - Row of Text data - Sheet 1
Columns B C D E
RowNo. 1 41-42 50-51 55-56 59-60
If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
Expected Results - returned in Column A - New Sheet
Column A
RowNo.8 41-42
RowNo.9 50-51
RowNo.10 55-56
RowNo.11 59-60
Thanks
Sam
How do I Index a Row of Text values in one Sheet and Return the Text data to
a NEW Sheet in one Column?
Sample - Row of Text data - Sheet 1
Columns B C D E
RowNo. 1 41-42 50-51 55-56 59-60
If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
Expected Results - returned in Column A - New Sheet
Column A
RowNo.8 41-42
RowNo.9 50-51
RowNo.10 55-56
RowNo.11 59-60
Thanks
Sam