Hello -
My first post!
I have a data set that has a very large amount of data, most of it is perfect, but the date fields have extra data in them (ex: "Jan-Actuals", "Jan-Budget"). They show up not as dates but as numbers (sum).
I know I could do some fancy Excel formatting (LEFT(cell.....) etc., but then wind up with extra rows across the the top.
Trying to make a trending analysis is obviously not going to be easy.
Tried to see where to attach an excel doc but did not see the clip icon.
What I have (obviously not real data):
| Critter | Food | Jan-Budget | Feb-Budget | Mar-Budget | Apr-Budget | May-Budget | Jan-Actual | Feb-Actual | Feb-Actual | Mar-Actual | Apr-Actual | May-Actual |
| Basset Hounds | Kibble | $100 | $300 | $500 | $700 | $900 | $1,100 | $1,300 | $1,500 | $1,700 | $1,900 | $2,100 |
| Golden Retrievers | Kibble | $100 | $300 | $500 | $700 | $900 | $1,100 | $1,300 | $1,500 | $1,700 | $1,900 | $2,100 |
| Samoyed | My shoes | $100 | $300 | $500 | $700 | $900 | $1,100 | $1,300 | $1,500 | $1,700 | $1,900 | $2,100 |
| Cows | Grass | $100 | $300 | $500 | $700 | $900 | $1,100 | $1,300 | $1,500 | $1,700 | $1,900 | $2,100 |
| Llamas | Not sure | $100 | $300 | $500 | $700 | $900 | $1,100 | $1,300 | $1,500 | $1,700 | $1,900 | $2,100 |
Should I ask to have Actual, budget, etc. slung underneath each critter? That would make for an enormous file.
Westy
