I have been wondering what is possible with data when it comes to you in a variety of ways. I am hoping to learn some tricks and advice as the experts might know how to deal with it?
I copied a set of records from the Dell website as an example. So this data is just a generalization of what I might get back from a number of sources. It is not the only way I get data handed to me.
If I get the data in a format like the file ExcelDataSample_DataAsIs but would like to put it in a more manageable format like what is visible in ExcelSample_ActualvsDesire
What would be the best option(s) The only ones I "think might" be able to do it is. YOU MIGHT WANT TO LOOK AT THIS FIRST...... ExcelSample_ActualvsDesire
- Formula or Function that may or may not be able to format it correctly in positions that can be managed like a table.
- A Macro that can order the list but the length (or number of items) transitioning from one to another is different for each item in the list.
- Some kind of an import / export trick I probably do not know if that is even possible though.