Pam in TX
03-23-2015, 01:17 PM
I currently have a file with multiple rows of data per person. Column D has a unique ID # for each person. I need each row of in column H converted to columns beginning in column N creating a new row whenever the ID # changes. The information below are other columns which data remains the same for each ID #.
Column A - Last Name
Column B - First Name
Column C - Grade
Column D - ID
Column E - Home School
Column F - Year
Column G - Math
Column H - Accom Number
Thank you in advance for your assistance.
Column A - Last Name
Column B - First Name
Column C - Grade
Column D - ID
Column E - Home School
Column F - Year
Column G - Math
Column H - Accom Number
Thank you in advance for your assistance.