VBA Help: transpose data, delete transposed data

[taxx411]

I have a database file that did not export correctly.

I need to Transpose a5:a18 into b4:q4

After transposing delete a5:a18

do that for every owner's name.

A2:Q2 has been done manually to show you the final product.

FYI: The original file has about 40k rows. So if possible please structure your code to accommodate larger files. Ty.

[JohnTopley]

Please Login or Register  to view this content.

Sheet1 copied to "test" which a has the result.

In "Sheet1" there are 2 entries with 16 lines so I deleted the last entry of each. If 16 entries is valid then code needs to be amended to test for variable length entries.

[Sintek]

Please Login or Register  to view this content.

[JohnTopley]

Please Login or Register  to view this content.

Both macros in the attached

[taxx411]

Thanks for helping but data all over the place.

[Sintek]

data all over the place.

I am guessing then that your actual file is not a constant group of 15 data points...Is this so...
Is there sometimes 15, then 16, then 15 etc etc
Perhaps you should upload a sample file reflecting actual setup...

[JohnTopley]

In "Sheet1" there are 2 entries with 16 lines so I deleted the last entry of each. If 16 entries is valid then code needs to be amended to test for variable length entries.

I did alert you to this in post #2!

Looking at your posted file there is no obvious delimiter: possibly a numeric value following the Zip Code ?