Hi YP,

Send me a sample of the data if you can, if not please diagram a sample of
your data here.

--
Thanks,
Shane Devenshire


"YP" wrote:

I have a table that is created by copying and pasting text from a pdf file.
The problem isthat when the text is pasted into excell it does not recoginzed
the missing data in somr rows so everthing is aligend in column A. I do a
filter to identify what rows need to be moved to the right 5 cells. I need
to cut only the visible cells with data in cells A-K and paste it in cells
F-P. Every time I try it I get an error that the function cannot be done.
Please help me, is there a macro I can create or a formula I can paste.

Thanks,