Spreadsheet: 868561d1715268868-make-new-column-with-last-populated-column-of-a-series-of-columns-using-power-query-excel-category-sample
Sheet: Sheet1

id | id.1 | id.2 | id.3 | id.4 | Last column Data | last_v
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | e975a4b1-d864-4015-957b-830061d7aea3 | a0fae7f8-39fa-4fcd-a5c4-727c9aae908e |  | a0fae7f8-39fa-4fcd-a5c4-727c9aae908e | a0fae7f8-39fa-4fcd-a5c4-727c9aae908e
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | e975a4b1-d864-4015-957b-830061d7aea3 | 9d15870d-7284-46d9-9385-44a7fedea947 |  | 9d15870d-7284-46d9-9385-44a7fedea947 | 9d15870d-7284-46d9-9385-44a7fedea947
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | e975a4b1-d864-4015-957b-830061d7aea3 | 3836421a-e254-4426-9020-5fd8ca9e5403 |  | 3836421a-e254-4426-9020-5fd8ca9e5403 | 3836421a-e254-4426-9020-5fd8ca9e5403
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | e975a4b1-d864-4015-957b-830061d7aea3 | 1c81d7e8-9a61-4a8e-95e7-b3d6c2c22843 |  | 1c81d7e8-9a61-4a8e-95e7-b3d6c2c22843 | 1c81d7e8-9a61-4a8e-95e7-b3d6c2c22843
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | e975a4b1-d864-4015-957b-830061d7aea3 | f34579a3-fe9d-4997-81c5-21ee703f45ec |  | f34579a3-fe9d-4997-81c5-21ee703f45ec | f34579a3-fe9d-4997-81c5-21ee703f45ec
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 044e1055-d4fc-4196-9f18-7e22c8ff73d4 | 04b80df0-f4e7-49e2-927d-e1b5bfa5a4c3 |  | 04b80df0-f4e7-49e2-927d-e1b5bfa5a4c3 | 04b80df0-f4e7-49e2-927d-e1b5bfa5a4c3
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 0f50ceb7-9a40-43ff-a408-efe9773c42bd |  |  | 0f50ceb7-9a40-43ff-a408-efe9773c42bd | 0f50ceb7-9a40-43ff-a408-efe9773c42bd
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 9ca58468-b413-44cc-8977-a8a4ea8529a6 |  |  | 9ca58468-b413-44cc-8977-a8a4ea8529a6 | 9ca58468-b413-44cc-8977-a8a4ea8529a6
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | b26b7ef1-60e5-49e8-9bde-04aa44b5cff1 | c4e825fe-a21a-4a95-927b-9c2c62547f2b |  | c4e825fe-a21a-4a95-927b-9c2c62547f2b | c4e825fe-a21a-4a95-927b-9c2c62547f2b
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 4775fe8e-e12d-44f7-835e-76b3bcde5b48 | 3846e38b-820c-400a-b01a-bbe7bad2fe63 |  | 3846e38b-820c-400a-b01a-bbe7bad2fe63 | 3846e38b-820c-400a-b01a-bbe7bad2fe63
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 4775fe8e-e12d-44f7-835e-76b3bcde5b48 | e3a972cc-c7a3-4e97-bdf3-c33b44bec47b |  | e3a972cc-c7a3-4e97-bdf3-c33b44bec47b | e3a972cc-c7a3-4e97-bdf3-c33b44bec47b
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 4775fe8e-e12d-44f7-835e-76b3bcde5b48 | bffcc8b9-6232-4e71-bd50-df713ec1ecd7 |  | bffcc8b9-6232-4e71-bd50-df713ec1ecd7 | bffcc8b9-6232-4e71-bd50-df713ec1ecd7
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 4775fe8e-e12d-44f7-835e-76b3bcde5b48 | 2519b19b-423d-4b5d-ab04-459449c5bae0 |  | 2519b19b-423d-4b5d-ab04-459449c5bae0 | 2519b19b-423d-4b5d-ab04-459449c5bae0
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 4775fe8e-e12d-44f7-835e-76b3bcde5b48 | 422c5808-82e1-445d-9fff-0c5f6700251c |  | 422c5808-82e1-445d-9fff-0c5f6700251c | 422c5808-82e1-445d-9fff-0c5f6700251c
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 1a1f82fa-1cb6-4fbc-aff7-2a52769e68de | 60281070-4ce6-427d-833f-6046ad4bb51c |  | 60281070-4ce6-427d-833f-6046ad4bb51c | 60281070-4ce6-427d-833f-6046ad4bb51c
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 1a1f82fa-1cb6-4fbc-aff7-2a52769e68de | 37132aa4-f687-4ca7-9be5-f7a1de9c6f9a |  | 37132aa4-f687-4ca7-9be5-f7a1de9c6f9a | 37132aa4-f687-4ca7-9be5-f7a1de9c6f9a
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 1a1f82fa-1cb6-4fbc-aff7-2a52769e68de | 37f97183-c09c-4e7e-b7c3-c6bb248266ba |  | 37f97183-c09c-4e7e-b7c3-c6bb248266ba | 37f97183-c09c-4e7e-b7c3-c6bb248266ba
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 1a1f82fa-1cb6-4fbc-aff7-2a52769e68de | 0f46c5eb-3b0b-469a-8fc5-269c34ea416c |  | 0f46c5eb-3b0b-469a-8fc5-269c34ea416c | 0f46c5eb-3b0b-469a-8fc5-269c34ea416c
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 1a1f82fa-1cb6-4fbc-aff7-2a52769e68de | 3542f243-672f-4845-90eb-9203e8d62fb1 |  | 3542f243-672f-4845-90eb-9203e8d62fb1 | 3542f243-672f-4845-90eb-9203e8d62fb1
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | d6b5f3ef-ba40-41c7-a16d-8069a416f894 |  |  | d6b5f3ef-ba40-41c7-a16d-8069a416f894 | d6b5f3ef-ba40-41c7-a16d-8069a416f894
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 6fbd2485-4fa0-48da-bceb-b53136a4e5f2 | 95983d42-a5a0-481b-9afc-6a619e0db10b |  | 95983d42-a5a0-481b-9afc-6a619e0db10b | 95983d42-a5a0-481b-9afc-6a619e0db10b
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 0a8b569c-c6ad-4985-967e-c69b0812d4a2 |  |  | 0a8b569c-c6ad-4985-967e-c69b0812d4a2 | 0a8b569c-c6ad-4985-967e-c69b0812d4a2
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 8f485688-6320-4697-9dce-e5224b0db09c |  |  | 8f485688-6320-4697-9dce-e5224b0db09c | 8f485688-6320-4697-9dce-e5224b0db09c
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 73e72445-1d7a-4490-ab7a-88760e1cf8d2 |  |  | 73e72445-1d7a-4490-ab7a-88760e1cf8d2 | 73e72445-1d7a-4490-ab7a-88760e1cf8d2
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 2c638c13-a6ea-4e8c-add9-777736dfbaba | 062ad819-af4e-4a18-8670-c2ff85922c51 | 5cdd9fd3-7be0-47dc-aa17-cf3b36f886c4 | 5cdd9fd3-7be0-47dc-aa17-cf3b36f886c4 | 5cdd9fd3-7be0-47dc-aa17-cf3b36f886c4
[NAME] | d1284e4e-cad8-4688-b9ce-50fc2713aa6e | 2c638c13-a6ea-4e8c-add9-777736dfbaba | 062ad819-af4e-4a18-8670-c2ff85922c51 | f1e2242e-a2c2-4a7c-a82c-97501240519c | f1e2242e-a2c2-4a7c-a82c-97501240519c | f1e2242e-a2c2-4a7c-a82c-97501240519c