Moving Data from Columns to Rows

[rlight1959]

Help! before I do manual keying of data, I wanted to ask this question.  Not sure thIs is possible; is there a way to move data from two columns into the rows.  I tried Transpose function and a few other things and nothing has worked.  With everything I have tired it will put the 1st column across the top and the second column underneath not side by side, see below.  I appreciate any help with this!!!!

It looks like this:

Sample, Name	$1,439.05	83.10
Sample, Name	$1,463.28	84.05
Sample, Name	$1,400.04	81.57
Sample, Name	$1,392.90	81.40

I need it to look like this:

Sample, Name

1439.05

83.1

1463.28

84.05

1400.04

8157

1392.9

81.4

[#2]

@rlight1959 Here is a formula you can use.  I have the data in the range b1:c4

=INDEX(B1:C4,INT(SEQUENCE(1,2*ROWS(B1:C4),1,0.5)),ISEVEN(SEQUENCE(1,2*ROWS(B1:C4)))+1)

[#3]

@rlight1959 I suspect that your real data contains many more rows and maybe not all groups of names contain 4 rows. Or perhaps, the names aren't even sorted to begin with. If so, then you may want to consider Power Query. The attached workbook contains an example. Perhaps you find it a helpful alternative.