Spreadsheet: 878614d1725776127-help-to-make-inventory-list-it_electronics2000-inventory-sample-2016-aligw
Sheet: Input Data

Trx ID | Date | Barcode | Item Name | Location | Trx Type | Qty | Transfer To
 | 2024-08-01 00:00:00 | 1000 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1001 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1002 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1003 |  |  | Initial Stock | 35
 | 2024-08-01 00:00:00 | 1004 |  |  | Initial Stock | 30
 | 2024-08-01 00:00:00 | 1005 |  |  | Initial Stock | 14
 | 2024-08-01 00:00:00 | 1006 |  |  | Initial Stock | 39
 | 2024-08-01 00:00:00 | 1007 |  | Warehouse | Initial Stock | 32
 | 2024-08-01 00:00:00 | 1008 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1009 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1010 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1011 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1012 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1013 |  |  | Initial Stock | 37
 | 2024-08-01 00:00:00 | 1014 |  |  | Initial Stock | 47
 | 2024-08-01 00:00:00 | 1015 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1016 |  |  | Initial Stock | 20
 | 2024-08-01 00:00:00 | 1017 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1018 |  |  | Initial Stock | 31
 | 2024-08-01 00:00:00 | 1019 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1020 |  |  | Initial Stock | 33
 | 2024-08-01 00:00:00 | 1021 |  |  | Initial Stock | 38
 | 2024-08-01 00:00:00 | 1022 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1023 |  |  | Initial Stock | 16
 | 2024-08-01 00:00:00 | 1024 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1025 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1026 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1027 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1028 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1029 |  |  | Initial Stock | 19
 | 2024-08-01 00:00:00 | 1030 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1031 |  |  | Initial Stock | 16
 | 2024-08-01 00:00:00 | 1032 |  |  | Initial Stock | 40
 | 2024-08-01 00:00:00 | 1033 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1034 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1035 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1036 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1037 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1038 |  |  | Initial Stock | 5
 | 2024-08-01 00:00:00 | 1039 |  |  | Initial Stock | 5
 | 2024-08-01 00:00:00 | 1040 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1041 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1042 |  |  | Initial Stock | 9
 | 2024-08-01 00:00:00 | 1043 |  |  | Initial Stock | 9
 | 2024-08-01 00:00:00 | 1044 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1045 |  |  | Initial Stock | 80
 | 2024-08-01 00:00:00 | 1046 |  |  | Initial Stock | 77
 | 2024-08-01 00:00:00 | 1047 |  |  | Initial Stock | 95
 | 2024-08-01 00:00:00 | 1048 |  |  | Initial Stock | 96
 | 2024-08-01 00:00:00 | 1049 |  |  | Initial Stock | 100
 | 2024-08-01 00:00:00 | 1050 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1051 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1052 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1053 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1054 |  |  | Initial Stock | 84
 | 2024-08-01 00:00:00 | 1055 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1056 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1057 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1058 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1059 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1060 |  |  | Initial Stock | 5
 | 2024-08-01 00:00:00 | 1061 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1062 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1063 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1064 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1065 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1066 |  |  | Initial Stock | 13
 | 2024-08-01 00:00:00 | 1067 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1068 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1069 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1070 |  |  | Initial Stock | 44
 | 2024-08-01 00:00:00 | 1071 |  |  | Initial Stock | 48
 | 2024-08-01 00:00:00 | 1072 |  |  | Initial Stock | 49
 | 2024-08-01 00:00:00 | 1073 |  |  | Initial Stock | 75
 | 2024-08-01 00:00:00 | 1074 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1075 |  |  | Initial Stock | 94
 | 2024-08-01 00:00:00 | 1076 |  |  | Initial Stock | 77
 | 2024-08-01 00:00:00 | 1077 |  |  | Initial Stock | 8
 | 2024-08-01 00:00:00 | 1078 |  |  | Initial Stock | 28
 | 2024-08-01 00:00:00 | 1079 |  |  | Initial Stock | 8
 | 2024-08-01 00:00:00 | 1080 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1081 |  |  | Initial Stock | 13
 | 2024-08-01 00:00:00 | 1082 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1083 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1084 |  |  | Initial Stock | 19
 | 2024-08-01 00:00:00 | 1085 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1086 |  |  | Initial Stock | 26
 | 2024-08-01 00:00:00 | 1087 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1088 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1089 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1090 |  |  | Initial Stock | 8
 | 2024-08-01 00:00:00 | 1091 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1092 |  |  | Initial Stock | 85
 | 2024-08-01 00:00:00 | 1093 |  |  | Initial Stock | 13
 | 2024-08-01 00:00:00 | 1094 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1095 |  |  | Initial Stock | 15
 | 2024-08-01 00:00:00 | 1096 |  |  | Initial Stock | 32
 | 2024-08-01 00:00:00 | 1097 |  |  | Initial Stock | 69
 | 2024-08-01 00:00:00 | 1098 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1099 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1100 |  |  | Initial Stock | 55
 | 2024-08-01 00:00:00 | 1101 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1102 |  |  | Initial Stock | 36
 | 2024-08-01 00:00:00 | 1103 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1104 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1105 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1106 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1107 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1108 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1109 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1110 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1111 |  |  | Initial Stock | 23
 | 2024-08-01 00:00:00 | 1112 |  |  | Initial Stock | 23
 | 2024-08-01 00:00:00 | 1113 |  |  | Initial Stock | 18
 | 2024-08-01 00:00:00 | 1114 |  |  | Initial Stock | 28
 | 2024-08-01 00:00:00 | 1115 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1116 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1117 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1118 |  |  | Initial Stock | 43
 | 2024-08-01 00:00:00 | 1119 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1120 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1121 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1122 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1123 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1124 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1125 |  |  | Initial Stock | 29
 | 2024-08-01 00:00:00 | 1126 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1127 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1128 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1129 |  |  | Initial Stock | 16
 | 2024-08-01 00:00:00 | 1130 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1131 |  |  | Initial Stock | 27
 | 2024-08-01 00:00:00 | 1132 |  |  | Initial Stock | 37
 | 2024-08-01 00:00:00 | 1133 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1134 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1135 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1136 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1137 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1138 |  |  | Initial Stock | 46
 | 2024-08-01 00:00:00 | 1139 |  |  | Initial Stock | 30
 | 2024-08-01 00:00:00 | 1140 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1141 |  |  | Initial Stock | 13
 | 2024-08-01 00:00:00 | 1142 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1143 |  |  | Initial Stock | 5
 | 2024-08-01 00:00:00 | 1144 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1145 |  |  | Initial Stock | 27
 | 2024-08-01 00:00:00 | 1146 |  |  | Initial Stock | 107
 | 2024-08-01 00:00:00 | 1147 |  |  | Initial Stock | 20
 | 2024-08-01 00:00:00 | 1148 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1149 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1150 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1151 |  |  | Initial Stock | 15
 | 2024-08-01 00:00:00 | 1152 |  |  | Initial Stock | 80
 | 2024-08-01 00:00:00 | 1153 |  |  | Initial Stock | 109
 | 2024-08-01 00:00:00 | 1154 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1155 |  |  | Initial Stock | 31
 | 2024-08-01 00:00:00 | 1156 |  |  | Initial Stock | 53
 | 2024-08-01 00:00:00 | 1157 |  |  | Initial Stock | 85
 | 2024-08-01 00:00:00 | 1158 |  |  | Initial Stock | 80
 | 2024-08-01 00:00:00 | 1159 |  |  | Initial Stock | 236
 | 2024-08-01 00:00:00 | 1160 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1161 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1162 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1163 |  |  | Initial Stock | 28
 | 2024-08-01 00:00:00 | 1164 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1165 |  |  | Initial Stock | 9
 | 2024-08-01 00:00:00 | 1166 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1167 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1168 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1169 |  |  | Initial Stock | 25
 | 2024-08-01 00:00:00 | 1170 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1171 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1172 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1173 |  |  | Initial Stock | 17
 | 2024-08-01 00:00:00 | 1174 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1175 |  |  | Initial Stock | 365
 | 2024-08-01 00:00:00 | 1176 |  |  | Initial Stock | 132
 | 2024-08-01 00:00:00 | 1177 |  |  | Initial Stock | 95
 | 2024-08-01 00:00:00 | 1178 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1179 |  |  | Initial Stock | 280
 | 2024-08-01 00:00:00 | 1180 |  |  | Initial Stock | 154
 | 2024-08-01 00:00:00 | 1181 |  |  | Initial Stock | 72
 | 2024-08-01 00:00:00 | 1182 |  |  | Initial Stock | 26
 | 2024-08-01 00:00:00 | 1183 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1184 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1185 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1186 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1187 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1188 |  |  | Initial Stock | 62
 | 2024-08-01 00:00:00 | 1189 |  |  | Initial Stock | 47
 | 2024-08-01 00:00:00 | 1190 |  |  | Initial Stock | 61
 | 2024-08-01 00:00:00 | 1191 |  |  | Initial Stock | 203
 | 2024-08-01 00:00:00 | 1192 |  |  | Initial Stock | 58
 | 2024-08-01 00:00:00 | 1193 |  |  | Initial Stock | 34
 | 2024-08-01 00:00:00 | 1194 |  |  | Initial Stock | 10
 | 2024-08-01 00:00:00 | 1195 |  |  | Initial Stock | 139
 | 2024-08-01 00:00:00 | 1196 |  |  | Initial Stock | 34
 | 2024-08-01 00:00:00 | 1197 |  |  | Initial Stock | 6
 | 2024-08-01 00:00:00 | 1198 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1199 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1200 |  |  | Initial Stock | 39
 | 2024-08-01 00:00:00 | 1201 |  |  | Initial Stock | 14
 | 2024-08-01 00:00:00 | 1202 |  |  | Initial Stock | 24
 | 2024-08-01 00:00:00 | 1203 |  |  | Initial Stock | 30
 | 2024-08-01 00:00:00 | 1204 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1205 |  |  | Initial Stock | 9
 | 2024-08-01 00:00:00 | 1206 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1207 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1208 |  |  | Initial Stock | 19
 | 2024-08-01 00:00:00 | 1209 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1210 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1211 |  |  | Initial Stock | 22
 | 2024-08-01 00:00:00 | 1212 |  |  | Initial Stock | 37
 | 2024-08-01 00:00:00 | 1213 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1214 |  |  | Initial Stock | 2
 | 2024-08-01 00:00:00 | 1215 |  |  | Initial Stock | 18
 | 2024-08-01 00:00:00 | 1216 |  |  | Initial Stock | 28
 | 2024-08-01 00:00:00 | 1217 |  |  | Initial Stock | 31
 | 2024-08-01 00:00:00 | 1218 |  |  | Initial Stock | 34
 | 2024-08-01 00:00:00 | 1219 |  |  | Initial Stock | 63
 | 2024-08-01 00:00:00 | 1220 |  |  | Initial Stock | 7
 | 2024-08-01 00:00:00 | 1221 |  |  | Initial Stock | 4
 | 2024-08-01 00:00:00 | 1222 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1223 |  |  | Initial Stock | 12
 | 2024-08-01 00:00:00 | 1224 |  |  | Initial Stock | 3
 | 2024-08-01 00:00:00 | 1225 |  |  | Initial Stock | 11
 | 2024-08-01 00:00:00 | 1226 |  |  | Initial Stock | 24
 | 2024-08-01 00:00:00 | 1227 |  |  | Initial Stock | 1
 | 2024-08-01 00:00:00 | 1228 |  |  | Initial Stock | 107
 | 2024-08-01 00:00:00 | 1229 |  |  | Initial Stock | 106
 | 2024-08-01 00:00:00 | 1230 |  |  | Initial Stock | 185
 | 2024-08-01 00:00:00 | 1231 |  |  | Initial Stock | 106
 | 2024-08-01 00:00:00 | 1232 |  |  | Initial Stock | 185
 | 2024-08-01 00:00:00 | 1233 |  |  | Initial Stock | 453
 | 2024-08-01 00:00:00 | 1234 |  |  | Initial Stock | 371
 | 2024-08-01 00:00:00 | 1235 |  |  | Initial Stock | 388
 | 2024-08-01 00:00:00 | 1236 |  |  | Initial Stock | 287
 | 2024-08-01 00:00:00 | 1237 |  |  | Initial Stock | 167
 | 2024-08-01 00:00:00 | 1238 |  |  | Initial Stock | 107