Match multiple columns in excel/access
September 8, 2011 12:41 PM Subscribe
I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such:
posted by thankyoumuchly to technology (3 answers total)
Current State: http://i.imgur.com/mR9PO.png
Desired State: http://i.imgur.com/k16ln.png
As you can see I'm going from the "fruit" columns being spread out across multiple columns, to having one master "fruit" column on the left, and individual monthly count columns on the right.
Can I do this easily in excel and/or access?