Timeline for Combining sheets with different number of colums and rows
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 7 at 17:35 | answer | added | Blindspots | timeline score: 0 | |
| Feb 16, 2023 at 18:23 | comment | added | Ron Rosenfeld |
You can do this with Power Query. Make them Tables. Then join the two tables with a JoinKind.FullOuter
|
|
| Feb 16, 2023 at 10:35 | history | edited | Diego R | CC BY-SA 4.0 |
added 15 characters in body; edited tags
|
| Feb 16, 2023 at 10:16 | history | edited | Diego R | CC BY-SA 4.0 |
deleted 61 characters in body
|
| Feb 16, 2023 at 10:09 | comment | added | Dominique |
Ever heard of VLookup? This is exactly what you need.
|
|
| Feb 16, 2023 at 10:05 | history | edited | Service Desk Bunny | CC BY-SA 4.0 |
Improved formatting (image)
|
| Feb 16, 2023 at 9:53 | history | edited | Diego R | CC BY-SA 4.0 |
Added an example image because the table formatting doesn't seem to work
|
| S Feb 16, 2023 at 9:50 | review | First questions | |||
| Feb 16, 2023 at 10:09 | |||||
| S Feb 16, 2023 at 9:50 | history | asked | Diego R | CC BY-SA 4.0 |