Hi, I'm relatively new at this, forums, but here we go.
I have a file with multiple columns of data for a row that I need to convert to multiple records. For example;
HERE'S HOW I RECEIVE THE DATA
01 12.34 20110101 12.45 20110112 12.67 20110124
02 23.45 20100112 23.67 20100219
03 45.67 20120112 45.89 20120212 45.12 20110314
HERE'S WHAT I WANT
01 12.34 20110101
01 12.45 20110112
01 12.67 20110124
02 23.45 20100112
02 23.67 20100219
03 45.67 20120112
03 45.89 20120212
03 45.12 20110314
In the source data, every row contains the primary id for the row, and for columns B to AY, contains corresponding data for that record. In the attached sample file I have include what I want, rows 2-10, compared to what I get, rows 11-29.
Please help an old dog learn a new trick.
Thanks!
Bookmarks