Packlock Combination

[Burrgogi]

I have a 4 digit padlock like this one that I have forgotten the number to. I can buy a new lock for ~$15 but I'd rather try & unlock the one I have. I'd like to create an excel sheet that contains all the different possible combinations (10,000 of them). That way, I can keep track of the numbers I've tried.

This is what I have in mind or something similar to it.
https://i.imgur.com/UlGBZFM.png

If that's too difficult, I can just as easily make do with having all the numbers in column A, straight down starting at cell A1.

 

[sandy666]

if you are able to use PowerQuery (Get&Transform)
try this:

[SIZE=1]let
    Source = Table1,
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table1),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"source"}, {"Custom.source"}),
    #"Added Custom1" = Table.AddColumn(#"Expanded Custom", "Custom", each Table1),
    #"Expanded Custom1" = Table.ExpandTableColumn(#"Added Custom1", "Custom", {"source"}, {"Custom.source.1"}),
    #"Added Custom2" = Table.AddColumn(#"Expanded Custom1", "Custom", each Table1),
    #"Expanded Custom2" = Table.ExpandTableColumn(#"Added Custom2", "Custom", {"source"}, {"Custom.source.2"}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Expanded Custom2", {{"source", type text}, {"Custom.source", type text}, {"Custom.source.1", type text}, {"Custom.source.2", type text}}, "en-GB"),{"source", "Custom.source", "Custom.source.1", "Custom.source.2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"result")
in
    #"Merged Columns"[/SIZE]

example file: cartesian

 

[Logit]

.
Download workbook : https://www.amazon.com/clouddrive/share/NL404ELIgLqL8AXuU431Obuy6JNmb6vRymQqMNYuWdM

Sample of data :

0000	0001	0002	0003	0004	0005	0006	0007	0008	0009
0010	0011	0012	0013	0014	0015	0016	0017	0018	0019
0020	0021	0022	0023	0024	0025	0026	0027	0028	0029
0030	0031	0032	0033	0034	0035	0036	0037	0038	0039
0040	0041	0042	0043	0044	0045	0046	0047	0048	0049
0050	0051	0052	0053	0054	0055	0056	0057	0058	0059
0060	0061	0062	0063	0064	0065	0066	0067	0068	0069
0070	0071	0072	0073	0074	0075	0076	0077	0078	0079
0080	0081	0082	0083	0084	0085	0086	0087	0088	0089
0090	0091	0092	0093	0094	0095	0096	0097	0098	0099
0100	0101	0102	0103	0104	0105	0106	0107	0108	0109
0110	0111	0112	0113	0114	0115	0116	0117	0118	0119
0120	0121	0122	0123	0124	0125	0126	0127	0128	0129
0130	0131	0132	0133	0134	0135	0136	0137	0138	0139
0140	0141	0142	0143	0144	0145	0146	0147	0148	0149
0150	0151	0152	0153	0154	0155	0156	0157	0158	0159
0160	0161	0162	0163	0164	0165	0166	0167	0168	0169

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Burrgogi]

Logit, thank you for doing that. I need a blank row inserted in between each line so that I can mark it "Yes" or "No"
Example:

 

[Burrgogi]

Logit - please disregard my previous message.

Sandy666 - thanks for the file. It will do. What is PowerQuery by the way?

 

[sandy666]

What is PowerQuery by the way?

look at: https://support.office.com/en-us/ar...38c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US