Hello everyone
I import data from a web site that is formatted incorrectly for my needs. I have included two images below ( Raw Data Columns A-E) and then how I need the data to be formatted into a table format (Table Format Required Columns H-O) for vlookup purposes. (I currently do this task manually) Any formula solutions that this terrific forum can provide will be greatly appreciated.
Thank you
CazfromOz
I import data from a web site that is formatted incorrectly for my needs. I have included two images below ( Raw Data Columns A-E) and then how I need the data to be formatted into a table format (Table Format Required Columns H-O) for vlookup purposes. (I currently do this task manually) Any formula solutions that this terrific forum can provide will be greatly appreciated.
Thank you
CazfromOz