All Questions
6 questions
0
votes
1
answer
172
views
Excel VBA - If Column A is blank combine Column C of same row with Column C of row above
I have rows of data
Some rows are blank apart from Column C
If Column A is blank then I would like to concatenate Column C with column C from the row above - then delete the row. There could be ...
- 52
-1
votes
1
answer
520
views
Excel VBA - Row with merged cells, code for unmerging and Concatenating data
Hi - I have been stuck on some VBA - I have extracted some data which is displayed in columns - the problem is some of the data in column 3 has been put into 2 cells - meaning all the corresponding ...
- 52
1
vote
1
answer
38
views
Concatenate "Description" cells in excel if same transaction recognized
I extracted data from txt files and I was able to make all my columns match, however the "Description" cell was divided into 2 or sometimes 3 cells in rows below for what should be one item. Is there ...
- 11
1
vote
1
answer
3k
views
Concat Excel Column Cell Strings per row with comma
I have an excel file with some columns. I have been trying to merge the columns and keep the cell strings separated with a comma.
So, I want a new table with the concat results per row :
=...
- 2,886
1
vote
2
answers
3k
views
Macro to merge and concatenate cells in Excel for rows in which information on other columns matches
apologize if this is a common post, but couldn't find something that fully applies to me.
It's a very similar post to (except that instead of just merging the 2 cells, i am looking to merge and ...
- 49
6
votes
3
answers
16k
views
Excel - Merge rows with common values and concatenate the differences in one column
I would like to merge rows with common values and concatenate the differences in one column.
I think the easiest thing to do is show you an example.
Input:
Customer Name | NEW YORK | ...
- 99