Hi All,
I am very new to this forum and have joined as I am faced with what is, to me, a very difficult task.
I have a workbook containing 32000 rows of data spread over 3 columns.
Column A Column B Column C
The data is in parent child relationships, i.e. Column A is the parent of Column B and Column B is the parent of Column C.
I need to reformat the data so that it is only spread across 2 columns whilst maintaining the parent child relationship
Each row only contains text in a single column but many rows can have the text in the same column so whatever I write has to look for the cell in a row that contains the data and then copy the parent from the row above and paste it into the correct cell as shown above.
Easy huh.
Can anyone help me with this?
I have been able to write a word macro that does a lot of it by searching on string values but there are simply too many variables to exclude for it to be a good way to go.
The final output will be a csv file.
Many thanks
Chris Deal
I am very new to this forum and have joined as I am faced with what is, to me, a very difficult task.
I have a workbook containing 32000 rows of data spread over 3 columns.
Column A Column B Column C
The data is in parent child relationships, i.e. Column A is the parent of Column B and Column B is the parent of Column C.
I need to reformat the data so that it is only spread across 2 columns whilst maintaining the parent child relationship
Each row only contains text in a single column but many rows can have the text in the same column so whatever I write has to look for the cell in a row that contains the data and then copy the parent from the row above and paste it into the correct cell as shown above.
Easy huh.
Can anyone help me with this?
I have been able to write a word macro that does a lot of it by searching on string values but there are simply too many variables to exclude for it to be a good way to go.
The final output will be a csv file.
Many thanks
Chris Deal
Last edited: