AndersW
06-11-2019, 01:39 PM
Hi,
I have a excel sheet with about 4000 rows. In column A there is an ID for the text that is in Column B. the text that is in column B is a large amount of text for each cell in the original sheet. And there can be anything from 1 to 15 cells in Column B that share the same ID in Column A. In Column A the ID is only typed once since the cell there are merged.
So does any of you have a neat macro that could combine the context in Column B cells into one cell in Column C next to the first cells from B. The combined text in column C should start at a new line inside (char 10) inside the combined cell when picking text from the different cells in Column B
See attached excel workbook where I have given example of the setup and what I hope the outcome of the macro could look like.24369
I have a excel sheet with about 4000 rows. In column A there is an ID for the text that is in Column B. the text that is in column B is a large amount of text for each cell in the original sheet. And there can be anything from 1 to 15 cells in Column B that share the same ID in Column A. In Column A the ID is only typed once since the cell there are merged.
So does any of you have a neat macro that could combine the context in Column B cells into one cell in Column C next to the first cells from B. The combined text in column C should start at a new line inside (char 10) inside the combined cell when picking text from the different cells in Column B
See attached excel workbook where I have given example of the setup and what I hope the outcome of the macro could look like.24369