Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Merge" cells
Not sure if its the title is the appropriate but here it goes: I have the following information after a Vlookup and a formula in Cells A1:C2 A1: Atribute 1 B1: Blue C1: is a blank cell A2: Atribute 1 B2: is a Blank Cell C1: RED I would like to basically come up with one single row where the blanks are dircarded and "merge" the relevant information maintained, without copying and pasting because the number of rows is extensive. Basically I need: D1:Atribute 1 E1: Blue F1: RED Thanks! -- Portuga ------------------------------------------------------------------------ Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385 View this thread: http://www.excelforum.com/showthread...hreadid=509295 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Merge" cells
For this solution you will need an extra cell eg. H1, where you write =A1&B1&C1. The ambersant (&-sign) connects the content of te cells. If you need to put in helping words you must put the between quotes, like this: =A1&" has the following characteristic "&B1&C1 NSV -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=509295 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Merge" cells
Is it always 2 rows you want to "merge" if the 1st column has identical
entries i.e. are there always 2 rows with "Attribute 1" in column A and then 2 rows with another say Attribute 2? Hans |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Merge" cells
Thank you for the help, I wasnt aware that was possible to merge contents of the cells using "&". Great tip! I'm sure I will use in the future. As for my current problem I found another solution by using Pivot tables and some Macros. Doesnt solve this particular problem but goes around it. Thanks again! -- Portuga ------------------------------------------------------------------------ Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385 View this thread: http://www.excelforum.com/showthread...hreadid=509295 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |