Transpose Rows to Columns VBA Code and delete specific account numbers

[cowboys]

I am back I need one more help to complete my task. I want Transpose Rows to Columns and need to delete two account numbers (7000 and 3000) details from the data. I have attached a sample of my data set before(sheet1) and after(sheet2) and a screen shot too. my data set is more than 35 pages so, need a loop too. the address data is random. address data(C column) has various number of lines (2,3 or4) . After one row of data I have a 6 row gap to the next data. The data was converted from .txt file. please help ......

Attachment 194690Attachment 194691

Any help is appreciated and thank you for reading my post.Please help me!!!

[cowboys]

Please ...any help

[cowboys]

Atleast anyone can help on Transpose the Rows to Columns VBA Code ... please ...

[JOHN H. DAVIS]

A bit Rube Goldbergish, but this is the closest I could get. Hope it helps.

Please Login or Register  to view this content.

[cowboys]

Thanks! but ......