Separating data

[GatorFanDan]

I am trying to take 2 rows in Excel and put them into 1 row, spreadin
across 3 columns. For example:

Currently looks like this:

column A
row 1: Watch
row 2: $5.00 July 10th


I would like to make it look like this:

column A column B column C
row 1: Watch $5.00 July 10th


Thanks in advance,

Da

 

[Frank Kabel]

Hi
try the following formulas on your second sheet
A1:
=OFFSET('sheet1'!$A$1,(ROW()-1)*2,0)

B1:
=OFFSET('sheet1'!$A$2,(ROW()-1)*2,COLUMN()-2)
and copy to the right

afterwards copy A1:C1 down

 

[Soo Cheon Jheong]

Hi,

On your second sheet,

1) Try the following formulas

A1: =OFFSET(Sheet1!$A$1,ROW()*2-2,0)
B1: =OFFSET(Sheet1!$A$1,ROW()*2-1,0)
C1: =OFFSET(Sheet1!$A$1,ROW()*2-1,1)

2) Select A1:C1 and fill down


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

 

[GatorFanDan]

Thanks for the reply guys.

Do I just copy and paste the formulas on a new spreadsheet, thu
pulling data from the original spreasheet?

When I cut and paste the formula for cell A1 on the second spreadsheet
the cell A1 is populated with "#VALUE!" Not sure what is happening.
The same result happens for cells B1 and C1.

Any guesses?

Thanks,

Da

 

[GatorFanDan]

--