Return to Question

How can I combine two sheets with different number of rows and columns in Excel or Libre Office? Example:

Sheet 1:

Sheet 2:

Result:

How can I combine two sheets with different number of rows and columns in Excel, Libre Office or Google Sheets? Example:

Sheet 1:

Sheet 2:

Result:

How can I combine two sheets with different number of rows and columns in Excel or Libre Office? Example:

Sheet 1:

Sheet 2:

Result:

How can I combine two sheets with different number of rows and columns in Excel or Libre Office? Example:

Sheet 1:

Sheet 2:

Result:

How can I combine two sheets with different number of rows and columns in Excel or Libre Office? Example:

Sheet 1: | Name | Age | Phone | | ---- | --- | ----- | | Mike | 35 | 197 158 348 | | Dave | 38 | 394 953 429 |

Sheet 2: | Name | Email | Birthday | | ---- | --- | ----- | | Mike | [email protected] | 2/5/88 | | Dave | [email protected] | 3/7/85 | | John | [email protected] | 4/6/94 |

Result: | Name | Age | Phone | Email | Birthday | | ---- | --- | ----- | ----- | -------- | | Mike | 35 | 197 158 348 | [email protected] | 2/5/88 | | Dave | 38 | 394 953 429 | [email protected] | 3/7/85 | | John | | | [email protected] | 4/6/94 |

example

How can I combine two sheets with different number of rows and columns in Excel or Libre Office? Example:

Sheet 1:

Sheet 2:

Result: