combine cells

Hi, I’m a bit of an Excel noob, so I hope I’m able to express myself clearly. Using Office Professional Plus 2019 on a Windows 10 computer. I'm working with a large dataset of TV show transcripts. Column A ('speaker') has the names of the characters, and column B ('line') has the lines they...

Hi Team , Basically i need to copy the rows and cols which are not fixed, so it can increase daily from one sheet to another sheet in the same workbook. I am getting error in the end as "Run-time error '5' Invalid procedure call or argument, can you please help. Below is the vba code: Sub...

Hi! I need to combine multiple sheets to one "master sheet". The problem is that there is no unique id. But it can be created by combining the two columns (In this example Number & Name). But then the sheets have different amounts of rows also. How can I "overlay" so that I get all the...

I'm really not even sure what the best way to do what what I want is so I'll start by describing the desired outcome. I have a spreadsheet with say 10,000 product names in one column and attributes for each product in a row. Many of these rows are the same product but using a different name...

Hello all, i want to combine data in B column based on data in A column. If value of A column cells are same then adjacent B column cells should be combined as one cell. please refer the example for input and expected output. Thank you. ABCDEF1InputExpected Output2Column AColumn BColumn...

So i have a table created in Excel. I want to have a macro which allows me to fill a certain cell (lets say "B1") with the cell values from cell "A1" and "A2". Also i want that at the end of the cell there always is a "mm", if that makes any sense. Basicly what i want is the excel formula...

I am trying to pull data from to cells in a worksheet to name the tab of a new work sheet. I can make it work for data in one cell but not the two. Here is what i am using for the one ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value 'name sheet I would also like to...

I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...

I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...

Hello ! I have a excel sheet with 3 column data 1st column = has sr no. 2nd column = has no. of unit 3rd coloum = has individual total amount value Eg:- <tbody> # Unit TOTAL AMT 1 100 100.00 2 200 400.00 3 300 900.00 4 400 1,600.00 5 500 2,500.00 6 600 3,600.00 7 700 4,900.00...

I've tried using both: =A1&""&B1&""&C1 (also without the "") and =CONCATENATE(A1,B1,C1) However when referencing them in a simple lookup formula it gives an incorrect output. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col...

Hello, I have ports and ip addresses associated with ports and mac addresses. In some cases there may be more than 2 ip addresses associated with a port. I have data that looks like this: <tbody> Port IP address;Mac Address FA01 192.000.000.12;000.ae.ee 127.000.000.00;123.aa.bb FA02...

I am currently using this formula to retrieve and combine multiple cell data into one cell and make them comma separated JOIN(",",TRANSPOSE(B3:B69)) But is it possible to do the same but only retrieve cell data in column B is the corresponding A column cell equals certain criteria (example =...

I came up with a formula, but that would take longer then doing this by hand. Perhaps someone can help me write a macro?? Please :) A1: 54684 A2: 58321 A3: 38743 A4: 25786 The result would look as such: A5: 54684,58321,38743,25786 Keep in mind, in reality there would be hundreds of line...

Have 6 columns of data (like below but some columns could be blank or even all) and then a column that will summarize the preceding information such as the examples below: <colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> AG1 MSC1 MG1 SR1...

I've taken forever developing this formula that you guys can probably come up with in 2 minutes. Here it is: =RIGHT("000"&F2,6)&"/"&"501-"&RIGHT(D2,4) What it does is create a combined string using the first two columns. The string has to be in this format ######/501-#### but as you can see in...

I am having an impossible time finding a solution for this. I need to combine cell contents in an unusual way (see below), based on if there is an "x" in column A. See below for the exact representation of what I need to do in a worksheet with 200,000 total cells of content. Is there any hope...

Have a table with 4 columns, Need a macro to combine some filtered cell with corresponding cell values are appended with combined values. From A B C D 111 Meeting 5.711% 12-May-13 222...

I need some assistance in combining multiple cells into one and keeping the formatting the same. I currently have code that will combine the columns but it losses the leading zero on numbers less than 10. For instance I gave some examples of the current output. CURRENT <tbody> Hour Min Sec...

How do I create a formula that will combine only the cells in a range that are not blank. I tried this formula =IF(K3="",J3,K3&", "&L3&", "&M3&", "&N3&", "&O3&", "&P3&", "&Q3&", "&R3&", "&S3&", "&T3&", "&U3) but if K3 is not blank I get a comma for every blank cell. Example: 4T311Q, , , , ...