Small Query - Urgent

[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.

 

[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

 

[Don Guillett]

Please describe your urgency as we normally treat all questions as urgent.