RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Experts
This is the first time I am trying this function after watching a video online. I am trying to append 12 sheets of data into one with the help of Get Data option in Excel. In all the sheets the placement of the headings is the same. In the first sheet itself I am getting only 28 rows of data out of the 83 rows. Can someone correct me where am I going wrong.?
This is the first time I am trying this function after watching a video online. I am trying to append 12 sheets of data into one with the help of Get Data option in Excel. In all the sheets the placement of the headings is the same. In the first sheet itself I am getting only 28 rows of data out of the 83 rows. Can someone correct me where am I going wrong.?
Book1.xlsx | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |||
1 | Goods and Services Tax - GSTR 2A | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | Taxable inward supplies received from registered persons | |||||||||||||||||||||||||
5 | GSTIN of supplier | Trade/Legal name of the Supplier | Invoice details | Place of supply | Supply Attract Reverse Charge | Rate (%) | Taxable Value (₹) | Tax Amount | GSTR-1/IFF/GSTR-5 Filing Status | GSTR-1/IFF/GSTR-5 Filing Date | GSTR-1/IFF/GSTR-5 Filing Period | GSTR-3B Filing Status | Amendment made, if any | Tax Period in which Amended | Effective date of cancellation | Source | IRN | IRN date | ||||||||
6 | Invoice number | Invoice type | Invoice Date | Invoice Value (₹) | Integrated Tax (₹) | Central Tax (₹) | State/UT tax (₹) | Cess (₹) | ||||||||||||||||||
7 | 76XXXCU3468F1XG | NAME 01 | 11020072192 | R | 02-04-2020 | 88500 | Karnataka | N | 18 | 75000 | 13500 | 0 | 0 | 0 | Y | 30-Jun-20 | Apr-20 | Y | ||||||||
8 | 76XXXCU3468F1XG | NAME 01 | 11020072192-Total | R | 02-04-2020 | 88500 | Karnataka | N | - | 75000 | 13500 | 0 | 0 | 0 | Y | 30-Jun-20 | Apr-20 | Y | ||||||||
9 | ||||||||||||||||||||||||||
10 | 39XXXCI5569D1XG | NAME 02 | KA2001000353 | R | 30-04-2020 | 10903.2 | Karnataka | N | 18 | 9240 | 0 | 831.6 | 831.6 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
11 | 39XXXCI5569D1XG | NAME 02 | KA2001000353-Total | R | 30-04-2020 | 10903.2 | Karnataka | N | - | 9240 | 0 | 831.6 | 831.6 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
12 | ||||||||||||||||||||||||||
13 | 39XXXCI5569D1XG | NAME 02 | KA2002000107 | R | 20-04-2020 | 9440 | Karnataka | N | 18 | 8000 | 0 | 720 | 720 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
14 | 39XXXCI5569D1XG | NAME 02 | KA2002000107-Total | R | 20-04-2020 | 9440 | Karnataka | N | - | 8000 | 0 | 720 | 720 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
15 | ||||||||||||||||||||||||||
16 | 39XXXCI5569D1XG | NAME 02 | KA2002000108 | R | 20-04-2020 | 9440 | Karnataka | N | 18 | 8000 | 0 | 720 | 720 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
17 | 39XXXCI5569D1XG | NAME 02 | KA2002000108-Total | R | 20-04-2020 | 9440 | Karnataka | N | - | 8000 | 0 | 720 | 720 | 0 | Y | 16-May-20 | Apr-20 | Y | ||||||||
18 | ||||||||||||||||||||||||||
19 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00058 | R | 27-04-2020 | 1992 | Karnataka | N | 12 | 1778.56 | 0 | 106.71 | 106.71 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
20 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00058-Total | R | 27-04-2020 | 1992 | Karnataka | N | - | 1778.56 | 0 | 106.71 | 106.71 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
21 | ||||||||||||||||||||||||||
22 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00070 | R | 29-04-2020 | 9960 | Karnataka | N | 12 | 8892.8 | 0 | 533.57 | 533.57 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
23 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00070-Total | R | 29-04-2020 | 9960 | Karnataka | N | - | 8892.8 | 0 | 533.57 | 533.57 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
24 | ||||||||||||||||||||||||||
25 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00080 | R | 30-04-2020 | 1000 | Karnataka | N | 12 | 892.85 | 0 | 53.57 | 53.57 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
26 | 39XXXCG8733H1XG | NAME 03 | DMB2021/GIS00080-Total | R | 30-04-2020 | 1000 | Karnataka | N | - | 892.85 | 0 | 53.57 | 53.57 | 0 | Y | 06-May-20 | Apr-20 | Y | ||||||||
27 | ||||||||||||||||||||||||||
28 | 39XXBFR1637C1XO | NAME 01 | 21G0066 | R | 28-04-2020 | 660521 | Karnataka | N | 18 | 559763.75 | 0 | 50378.74 | 50378.74 | 0 | Y | 16-Jun-20 | Apr-20 | Y | ||||||||
29 | 39XXBFR1637C1XO | NAME 01 | 21G0066-Total | R | 28-04-2020 | 660521 | Karnataka | N | - | 559763.75 | 0 | 50378.74 | 50378.74 | 0 | Y | 16-Jun-20 | Apr-20 | Y | ||||||||
30 | ||||||||||||||||||||||||||
31 | 39XXBFR1637C1XO | NAME 02 | 21G0067 | R | 28-04-2020 | 279135 | Karnataka | N | 18 | 236555 | 0 | 21289.95 | 21289.95 | 0 | Y | 16-Jun-20 | Apr-20 | Y | ||||||||
32 | 39XXBFR1637C1XO | NAME 02 | 21G0067-Total | R | 28-04-2020 | 279135 | Karnataka | N | - | 236555 | 0 | 21289.95 | 21289.95 | 0 | Y | 16-Jun-20 | Apr-20 | Y | ||||||||
33 | ||||||||||||||||||||||||||
34 | 39XXBCL5745N1X4 | NAME 02 | 203373280200000 | R | 01-04-2020 | 420493 | Karnataka | N | 18 | 356350 | 0 | 32071.5 | 32071.5 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
35 | 39XXBCL5745N1X4 | NAME 02 | 203373280200000-Total | R | 01-04-2020 | 420493 | Karnataka | N | - | 356350 | 0 | 32071.5 | 32071.5 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
36 | ||||||||||||||||||||||||||
37 | 39XBXFS5757L1XX | NAME 02 | SBE-07 | R | 05-04-2020 | 306859 | Karnataka | N | 18 | 260050 | 0 | 23404.5 | 23404.5 | 0 | Y | 25-May-20 | Apr-20 | Y | ||||||||
38 | 39XBXFS5757L1XX | NAME 02 | SBE-07-Total | R | 05-04-2020 | 306859 | Karnataka | N | - | 260050 | 0 | 23404.5 | 23404.5 | 0 | Y | 25-May-20 | Apr-20 | Y | ||||||||
39 | ||||||||||||||||||||||||||
40 | 39XBXFS5757L1XX | NAME 03 | SBE-08 | R | 05-04-2020 | 1070333 | Karnataka | N | 18 | 907062 | 0 | 81635.58 | 81635.58 | 0 | Y | 25-May-20 | Apr-20 | Y | ||||||||
41 | 39XBXFS5757L1XX | NAME 03 | SBE-08-Total | R | 05-04-2020 | 1070333 | Karnataka | N | - | 907062 | 0 | 81635.58 | 81635.58 | 0 | Y | 25-May-20 | Apr-20 | Y | ||||||||
42 | ||||||||||||||||||||||||||
43 | 39XXXCB3894G1XJ | NAME 01 | BM2129I000154604 | R | 03-04-2020 | 10864 | Karnataka | N | 18 | 9206.78 | 0 | 828.61 | 828.61 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
44 | 39XXXCB3894G1XJ | NAME 01 | BM2129I000154604-Total | R | 03-04-2020 | 10864 | Karnataka | N | - | 9206.78 | 0 | 828.61 | 828.61 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
45 | ||||||||||||||||||||||||||
46 | 39XXBCD3611Q1XE | NAME 02 | BLR204366 | R | 08-04-2020 | 11034.62 | Karnataka | N | 18 | 550 | 0 | 49.5 | 49.5 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
47 | 39XXBCD3611Q1XE | NAME 02 | BLR204366-Total | R | 08-04-2020 | 11034.62 | Karnataka | N | - | 550 | 0 | 49.5 | 49.5 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
48 | ||||||||||||||||||||||||||
49 | 39XXBCD3611Q1XE | NAME 02 | KASIR00118134 | R | 30-04-2020 | 48598.79 | Karnataka | N | 18 | 41185.41 | 0 | 3706.69 | 3706.69 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
50 | 39XXBCD3611Q1XE | NAME 02 | KASIR00118134-Total | R | 30-04-2020 | 48598.79 | Karnataka | N | - | 41185.41 | 0 | 3706.69 | 3706.69 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
51 | ||||||||||||||||||||||||||
52 | 39XXCCS8676D1XY | NAME 02 | 9711047324 | R | 01-04-2020 | 5310 | Karnataka | N | 18 | 4500 | 0 | 405 | 405 | 0 | Y | 10-May-20 | Apr-20 | Y | ||||||||
53 | 39XXCCS8676D1XY | NAME 02 | 9711047324-Total | R | 01-04-2020 | 5310 | Karnataka | N | - | 4500 | 0 | 405 | 405 | 0 | Y | 10-May-20 | Apr-20 | Y | ||||||||
54 | ||||||||||||||||||||||||||
55 | 39XXCCS8676D1XY | NAME 03 | 9711047572 | R | 30-04-2020 | 30537.74 | Karnataka | N | 18 | 25879.44 | 0 | 2329.15 | 2329.15 | 0 | Y | 10-May-20 | Apr-20 | Y | ||||||||
56 | 39XXCCS8676D1XY | NAME 03 | 9711047572-Total | R | 30-04-2020 | 30537.74 | Karnataka | N | - | 25879.44 | 0 | 2329.15 | 2329.15 | 0 | Y | 10-May-20 | Apr-20 | Y | ||||||||
57 | ||||||||||||||||||||||||||
58 | 39XIXPG4517H1XN | NAME 01 | 882/APEX/20-21 | R | 30-04-2020 | 69476 | Karnataka | N | 0 | 69476 | 0 | 0 | 0 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
59 | 39XIXPG4517H1XN | NAME 01 | 882/APEX/20-21-Total | R | 30-04-2020 | 69476 | Karnataka | N | - | 69476 | 0 | 0 | 0 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
60 | ||||||||||||||||||||||||||
61 | 39XIXPG4517H1XN | NAME 02 | 883/APEX/20-21 | R | 30-04-2020 | 65017 | Karnataka | N | 0 | 65017 | 0 | 0 | 0 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
62 | 39XIXPG4517H1XN | NAME 02 | 883/APEX/20-21-Total | R | 30-04-2020 | 65017 | Karnataka | N | - | 65017 | 0 | 0 | 0 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
63 | ||||||||||||||||||||||||||
64 | 39XIXPG4517H1XN | NAME 02 | 884/APEX/20-21 | R | 30-04-2020 | 302844 | Karnataka | N | 18 | 256648 | 0 | 23098.32 | 23098.32 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
65 | 39XIXPG4517H1XN | NAME 02 | 884/APEX/20-21-Total | R | 30-04-2020 | 302844 | Karnataka | N | - | 256648 | 0 | 23098.32 | 23098.32 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
66 | ||||||||||||||||||||||||||
67 | 39XIXPG4517H1XN | NAME 02 | 885/APEX/20-21 | R | 30-04-2020 | 77338 | Karnataka | N | 18 | 65540 | 0 | 5898.6 | 5898.6 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
68 | 39XIXPG4517H1XN | NAME 02 | 885/APEX/20-21-Total | R | 30-04-2020 | 77338 | Karnataka | N | - | 65540 | 0 | 5898.6 | 5898.6 | 0 | Y | 31-May-20 | Apr-20 | Y | ||||||||
69 | ||||||||||||||||||||||||||
70 | 39XXXCY3768D1XC | NAME 01 | BBC0404206329630 | R | 04-04-2020 | 864763 | Karnataka | N | 18 | 732850 | 0 | 65956.5 | 65956.5 | 0 | Y | 19-May-20 | Apr-20 | Y | ||||||||
71 | 39XXXCY3768D1XC | NAME 01 | BBC0404206329630-Total | R | 04-04-2020 | 864763 | Karnataka | N | - | 732850 | 0 | 65956.5 | 65956.5 | 0 | Y | 19-May-20 | Apr-20 | Y | ||||||||
72 | ||||||||||||||||||||||||||
73 | 39XXXFI3788K1XW | NAME 02 | 0031/2020-21 | R | 30-04-2020 | 15340 | Karnataka | N | 18 | 13000 | 0 | 1170 | 1170 | 0 | Y | 13-May-20 | Apr-20 | Y | ||||||||
74 | 39XXXFI3788K1XW | NAME 02 | 0031/2020-21-Total | R | 30-04-2020 | 15340 | Karnataka | N | - | 13000 | 0 | 1170 | 1170 | 0 | Y | 13-May-20 | Apr-20 | Y | ||||||||
75 | ||||||||||||||||||||||||||
76 | 39XXFCC9473R1XL | NAME 02 | 447892945 | R | 03-04-2020 | 14819.38 | Karnataka | N | 12 | 13231.58 | 0 | 793.9 | 793.9 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
77 | 39XXFCC9473R1XL | NAME 02 | 447892945-Total | R | 03-04-2020 | 14819.38 | Karnataka | N | - | 13231.58 | 0 | 793.9 | 793.9 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
78 | ||||||||||||||||||||||||||
79 | 39XXFCC9473R1XL | NAME 02 | 447892946 | R | 03-04-2020 | 4878.72 | Karnataka | N | 12 | 4356 | 0 | 261.36 | 261.36 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
80 | 39XXFCC9473R1XL | NAME 02 | 447892946-Total | R | 03-04-2020 | 4878.72 | Karnataka | N | - | 4356 | 0 | 261.36 | 261.36 | 0 | Y | 11-May-20 | Apr-20 | Y | ||||||||
81 | ||||||||||||||||||||||||||
82 | 39BFXPR3739X1XU | NAME 03 | PE-02/2020-21 | R | 05-04-2020 | 266404 | Karnataka | N | 18 | 225766 | 0 | 20318.94 | 20318.94 | 0 | Y | 08-Jun-20 | Apr-20 | Y | ||||||||
83 | 39BFXPR3739X1XU | NAME 03 | PE-02/2020-21-Total | R | 05-04-2020 | 266404 | Karnataka | N | - | 225766 | 0 | 20318.94 | 20318.94 | 0 | Y | 08-Jun-20 | Apr-20 | Y | ||||||||
84 | ||||||||||||||||||||||||||
B2B |