Convert Multiple Column Values into 1 column
Thanks,
This is EXACTLY what I have been looking for!
Darian
"Teethless mama" wrote:
=OFFSET($A$1,MOD(ROWS($A$1:A1)-1,COUNTA($A$1:$A$6)),INT((ROWS($A$1:A1)-1)/COUNTA($A$1:$A$6)))
Copy down as far as needed.
"Darian" wrote:
Can you convert a worksheet with multiple columns and multiple rows of data
into 1 column?
CURRENT WORKSHEET STRUCTURE(assume A1=_-Insert, A2=MHS,etc.)
_-Insert _-Insert
MHS MHS-PROP
225,955,0 0,940,0
1.00 1.00
1.00 1.00
0.00 0.00
DESIRED RESULT
_-Insert
MHS
225,955,0
1.00
1.00
0.00
_-Insert
MHS-PROP
0,940,0
1.00
1.00
0.00
Any help is appreciated. Thanks!
|