i have sheet with data . i want to combine column A values with Column B values with this condition ..
IF sheet one have these values in Column A and Column B
then need values in sheet 2 like this
i tried to find some other ways to do THIS . but not able to find any online tool to do this so i think excel is only option for this to do this . so can you please help me in this .
IF sheet one have these values in Column A and Column B
HTML:
|----------------------------|--------------------------|
| Cell A | Cell B |
|----------------------------|--------------------------|
| Name 1 | Last Name 1 |
|----------------------------|--------------------------|
| Name 2 | Last Name 2 |
|----------------------------|--------------------------|
| Name 3 | Last Name 3 |
|----------------------------|--------------------------|
| Name 4 | Last Name 4 |
|----------------------------|--------------------------|
| Name 5 | Last Name 5 |
|----------------------------|--------------------------|
then need values in sheet 2 like this
HTML:
|----------------------------------------|
| Cell A |
|----------------------------------------|
| Name 1 - Last Name 1 |
|----------------------------------------|
| Name 1 - Last Name 2 |
|----------------------------------------|
| Name 1 - Last Name 3 |
|----------------------------------------|
| Name 1 - Last Name 4 |
|----------------------------------------|
| Name 1 - Last Name 5 |
|----------------------------------------|
|----------------------------------------|
| Cell B |
|----------------------------------------|
| Name 2 - Last Name 1 |
|----------------------------------------|
| Name 2 - Last Name 2 |
|----------------------------------------|
| Name 2 - Last Name 3 |
|----------------------------------------|
| Name 2 - Last Name 4 |
|----------------------------------------|
| Name 2 - Last Name 5 |
|----------------------------------------|
|----------------------------------------|
| Cell C |
|----------------------------------------|
| Name 3 - Last Name 1 |
|----------------------------------------|
| Name 3 - Last Name 2 |
|----------------------------------------|
| Name 3 - Last Name 3 |
|----------------------------------------|
| Name 3 - Last Name 4 |
|----------------------------------------|
| Name 3 - Last Name 5 |
|----------------------------------------| and continue TO SAME NAME 5
i tried to find some other ways to do THIS . but not able to find any online tool to do this so i think excel is only option for this to do this . so can you please help me in this .