Excel copy data

[Paul Gardiner]

Hi I have a file like this
aaa
12
113
14
bbb
25
12
58
alpha is the customer name and numbers are stock items purchased. all in one column
How do I get aaa to appear next to 12,113 and 14?
and bbb to appear next to 25,12 and 58?

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Asynchronous Page Processing
http://www.eggheadcafe.com/tutorial...ff-0249ad2b0bd2/aspnet-asynchronous-page.aspx

 

[Fred Smith]

It depends what you mean by "appear next to", but let's assume your data is
in column A, and you want the customer name in column B. In B1, enter =a1.
In B2, use:

=if(istext(a2),a2,b1)

and copy down.

Regards,
Fred

in message news:[email protected]...

 

[Ashish Mathur]

Hi,

Say your data is in range C3:C10. In D3, enter the following formula and
then copy down till D10

=IF(ISNUMBER(C3),LOOKUP(REPT("z",99),$C$3:C3),"")

There copy D310 and paste them as values. After this, you may delete the
text entries in C3:C10.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

in message news:[email protected]...