I'm working on data migration, need some help on doing a macro to copy/transpose multiple columns record into individual single row. There are also a "tag" in the first row, which indicates the columns that should not be included in the copy/transpose.
From:
Tag . . . . . . . . . .x
Name Jan Feb Mar Apr
Larry 2 20 34 56
Harry 3 45 77 88
Marry 5 66 44 33
To:
Larry Jan 2
Larry Feb 20
Larry Apr 56
Harry Jan 3
Harry Feb 45
Harry Apr 88
Marry Jan 5
Marry Feb 66
Marry Apr 33
The "Mar" data was omitted due to there's a tag (X) above it. The data might be near hundred columns (few years), and some of the months need to be omitted. Any expert able to help on this? I had been spending whole day cracking my head on this. Worse come to worse I might have to manually copy and paste, that would probably took me a decade.