Separating data

G

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
 
F

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
 
S

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
_ _
^¢¯^
--
 
G

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
 
Top