Hi,
The title is the only way I can explain it without making a stupidly long message.
Attachment 607147
Attachment 607148
I am trying to create a shortcut at work so that I dont have to Copy and Paste Values thousands of times. I need to have all my data streaming down in a CSV file so I can mass upload. Currently it is like a 2 way table with months across columns and Qty in the table. Is it possible to revert this to raw data (kind of like reversing a pivot table, although my table here is all in values) so that the data will repeat down aligned with Jan, Feb, Mar etc.
See attached photos, the first one is how it is (pivot table), the second one is the way I want it looking for all 500 customers!
I used the second customer down as this has data inputted. Customer 1 (3663) doesnt.
HOPE THIS MAKES SENSE
Bookmarks