J Jason Morin Jan 23, 2005 #2 Place this in B1 and fill across: =OFFSET($A$2,COLUMN()-2,) HTH Jason Atlanta, GA
A Arvi Laanemets Jan 23, 2005 #3 Hi Into B1 enter the formula =IF(A2="","",A2) and copy down Arvi Laanemets
G Guest Jan 23, 2005 #4 If it's headlines: A2:A10 right click Copy B1 right click Paste Special > Transpose Done! Ola
M Myrna Larson Jan 24, 2005 #5 Into B1 enter the formula =IF(A2="","",A2) Click to expand... That looks to me like it's going to give exactly the same results as =A2. What am I missing?
Into B1 enter the formula =IF(A2="","",A2) Click to expand... That looks to me like it's going to give exactly the same results as =A2. What am I missing?
D Dave Peterson Jan 24, 2005 #6 If a2 is empty, then =a2 will return a 0??? Myrna said: That looks to me like it's going to give exactly the same results as =A2. What am I missing? Click to expand...
If a2 is empty, then =a2 will return a 0??? Myrna said: That looks to me like it's going to give exactly the same results as =A2. What am I missing? Click to expand...
