Suggestion

Excel Help for Suggestion in Developing Business Administration Solutions

Suggestion

Rate this: (3/5 from 1 vote)

	Sh*t, I hate when a complete post gets lost... let's try again :/ The problem with the pivot table, is that if any of the records has a missing field you wouldn't be able to tell which field belongs to a record. Sample Data: Customer Enquire Name: John Doe Phone: 555-5555 Email: [email protected] Question: What time is it? Customer Enquire Name: Jane Doe Phone: 666-6666 Question: Whats 2+2? Customer Enquire Name: Larry Moe Email: [email protected] Question: To be or not to be? --- Note that there could be missing fields, like Phone or Email. In this case we would have this rows: 3 names, 2 phones, 2 email and 3 question it would be hard to tell who has a phone, an email or both. If one could use a special keyword, like 'Customer Enquire', as a record separator maybe the script could deal with this as beeing a different file.
	Alexandre
	Posted by oteacher on 22 Feb 2012

View Full Post