Need a MACRO which cleans vertical data in 1 column and transposes it to a new worksheet

This should do it, just make sure the raw data is onscreen when you start, there doesn't need to be any other sheets in the workbook other than that.

Please Login or Register  to view this content.

Hi JB,

WOW you are good! I've been messing around for 2 days trying to get something like that and you managed it in only a few hours! Wow thanks,

Now I ran into a bit of a snag since I checked some of the ORIGINAL data we have and found that most HOTELS have additional rows with info (which we don't need), but it's affecting the macro you created. ;-(

Attached is the RAW sample list of 10 hotels.

As you will notice we only need a certain block of each one. Based on this RAW sample, would you be able to modify the macro to pull out only the Highlighted parts. Also, could you make it loop until there is no more data on the sheet?

MANY MANY thanks for your kind assistance with this! Truly appreciate this!

This should get you closer to 100%. As always tends to happen, there may be some "tweaks" you need to do manually to correct an item here and there in the resulting sheet. Since the data is so perfectly formatted in the new sheet, they should jump out at you which ones you need to check. Like item #1 from the results of this corrected macro:

Please Login or Register  to view this content.