Hello! Here is the description of my data, and what I am attempting to do... your assistance will be much appreciated. I have also added a spreadsheet with sample data in Sheet 1 and how I would want the Macro to produce output in Sheet 2.
- I have Sheet 1 with 10 columns. The headers for columns are as such: Column A = Activity, and the Columns B through J = Task i.e. Task B, Task C ...Task J
- Each "Activty" in Column A has at least a "Task" in anyone of the columns B through J
- I am attempting to transpose the data in Task B through Task J columns into another Sheet i.e. Sheet 2, and place the "Task" Column data from multiple columns in Sheet 1, to a single column, Column A in Sheet 2
- Then I want to make a copy of the Activity from Column A in Sheet 1, and paste it next to the corresponding Tasks from Sheet 1, in Column B of Sheet 2. Depending on the number of rows the Columns Task B through J transposed into, the Activity would need to be copied down through each of corresponding Tasks.