Small Query - Urgent

S

showry

Hi All,

I need the a small help from you....
My Query is:

Data I required
asd asd
asd
asd
asd
asd
sdr sdr
sdr
sdr
sdr
sdr
fgr fgr
fgr
fgr
fgr
fgr
asd asd


what iam doing right now is, selecting copy and pasting... but it is
very difficult when iam working with 10k lines can i get as per above
with a code or small function or macro or any?

Thanks in advance.

Regards,
Anil.
 
R

Ron@Buy

Matt came up with this solution to a similar problem yesterday:

Assuming the Headers as described below are in cells A1 and B1 and the Data
begins in Cell A2, then

1.) Enter the following formula in Cell C2:

=IF(A2<>"",A2,OFFSET(C2,-1,0))

2.) Copy the formula down column C to match the last row of data in Column A

3.) Select and Copy the cells with the data in Column C

4.) Select Cell A2, right click --> Paste Special --> Select 'Values' -->
click Okay

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top