Trying to take raw data on 1 sheet, and make a nice formatted table on another

I have 2 tabs.

One tab is all my raw data which is in 1 column and it just goes row by row, which the data entry resetting every 25-27 rows or so. Then on my other sheet I have my table that I have started putting together with my raw data, which goes across by the column. What I've had to do is just copy paste and transpose the data for it to go in my table. However there are like 300 entries (each entry is name, date, dealer, company, etc... there's 20 data entries )

It's taking forever having to copy paste and transpose so the raw data fits into my table. Are there any faster ways of doing this?

I attached the file so you can see what I'm talking about, I've done the first couple entries. Basically the data entires on the 2nd tab are just separated by a dotted line ------ and there is one extra blank row.

Please I need some help to speed this up! Thank you in advance!

EDIT: If it helps each data section begins with the text <transaction> and ends with </transaction>

See if this works for you: run the macro "tst()" in the attachment.

WHER,

Very nicely done.

I see you added an addition column in worksheet Formatted Table, column S for fax.

Now, I need to study the code to see how it opperates.



I made a slight change to one line of your code so that the data in worksheet Formatted Table starts in row 2, the first blank/available row:

I changed this next line of code:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Thanks again - one for my archives.

WHER,

Can you suggest where I may be able to learn, read about, how you parsed this post's raw data?

WHER,

Thanks for responding.

I can use the link because it is not in English.

But, I will search for SNB's, and your, responses.

Thanks again.

WHER,

Thank you.