Hello,
I have data set-up in a matrix. There is a single row for each position # (4,332 records) in column A. In the next 134 columns (B:EE), there is a marking designating an assignment to that position #. There are multiple assignments to each position number and these number of assignments per position number varies. I need to convert this into a format in which there are multiple rows per position # (number of rows per position equal to the number of assignments it has) and then in the adjacent column I need each of the roles for that position listed. In other words, I have this:
Column A Column B Column C Column D Column E
Position 1 Assgn 1 Assgn 3 Assgn 4
Position 2 Assgn 2 Assgn 4
And I want it to look like this:
Column A Column B
Position 1 Assgn 1
Position 1 Assgn 3
Position 1 Assgn 4
Position 2 Asgn 2
Position 2 Assgn 4
I have attached an Excel file with the data. SHeet 1 contains the mapping data. Sheet 2 contains a sample of the first two positions in the format that I need to convert it to.
I would REALLY appreciate any help on this. I really appreciate any guidance or example code here. Thank you!!!
Bookmarks