Hi Robert Thanks for your reply, although I'm not sure if I understand your response. Looking at the code you supplied, will this not just display NA if "a" is empty, my problem is "a" might not be even created.
part no 23a has 3 measurements: a=0.32,b=0.34,c=0.45 part no 24a has 2 measurements: a=0.12,b=0.43 for part no 24a, I would need to display c=na, although c does not exist for this part no. My final output should resemble this Part NO: A B C D 23a 0.32 0.34 0.35 0.36 23a 0.32 0.34 NA NA 23a NA 0.34 0.12 0.34 If I have misunderstood you - sorry. Jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
