Get Data function in Excel

RAJESH1960

Banned for repeated rules violations
Joined
Mar 26, 2020
Messages
2,313
Office Version
  1. 2019
Platform
  1. 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.?
Book1.xlsx
ABCDEFGHIJKLMNOPQRSTUVWX
1Goods and Services Tax - GSTR 2A
2
3
4 Taxable inward supplies received from registered persons
5GSTIN of supplierTrade/Legal name of the SupplierInvoice detailsPlace of supplySupply Attract Reverse ChargeRate (%)Taxable Value (₹)Tax AmountGSTR-1/IFF/GSTR-5 Filing StatusGSTR-1/IFF/GSTR-5 Filing DateGSTR-1/IFF/GSTR-5 Filing PeriodGSTR-3B Filing StatusAmendment made, if anyTax Period in which AmendedEffective date of cancellationSourceIRNIRN date
6Invoice numberInvoice typeInvoice DateInvoice Value (₹)Integrated Tax (₹)Central Tax (₹)State/UT tax (₹)Cess (₹)
776XXXCU3468F1XGNAME 0111020072192R02-04-202088500KarnatakaN187500013500000Y30-Jun-20Apr-20Y
876XXXCU3468F1XGNAME 0111020072192-TotalR02-04-202088500KarnatakaN-7500013500000Y30-Jun-20Apr-20Y
9
1039XXXCI5569D1XGNAME 02KA2001000353R30-04-202010903.2KarnatakaN1892400831.6831.60Y16-May-20Apr-20Y
1139XXXCI5569D1XGNAME 02KA2001000353-TotalR30-04-202010903.2KarnatakaN-92400831.6831.60Y16-May-20Apr-20Y
12
1339XXXCI5569D1XGNAME 02KA2002000107R20-04-20209440KarnatakaN18800007207200Y16-May-20Apr-20Y
1439XXXCI5569D1XGNAME 02KA2002000107-TotalR20-04-20209440KarnatakaN-800007207200Y16-May-20Apr-20Y
15
1639XXXCI5569D1XGNAME 02KA2002000108R20-04-20209440KarnatakaN18800007207200Y16-May-20Apr-20Y
1739XXXCI5569D1XGNAME 02KA2002000108-TotalR20-04-20209440KarnatakaN-800007207200Y16-May-20Apr-20Y
18
1939XXXCG8733H1XGNAME 03DMB2021/GIS00058R27-04-20201992KarnatakaN121778.560106.71106.710Y06-May-20Apr-20Y
2039XXXCG8733H1XGNAME 03DMB2021/GIS00058-TotalR27-04-20201992KarnatakaN-1778.560106.71106.710Y06-May-20Apr-20Y
21
2239XXXCG8733H1XGNAME 03DMB2021/GIS00070R29-04-20209960KarnatakaN128892.80533.57533.570Y06-May-20Apr-20Y
2339XXXCG8733H1XGNAME 03DMB2021/GIS00070-TotalR29-04-20209960KarnatakaN-8892.80533.57533.570Y06-May-20Apr-20Y
24
2539XXXCG8733H1XGNAME 03DMB2021/GIS00080R30-04-20201000KarnatakaN12892.85053.5753.570Y06-May-20Apr-20Y
2639XXXCG8733H1XGNAME 03DMB2021/GIS00080-TotalR30-04-20201000KarnatakaN-892.85053.5753.570Y06-May-20Apr-20Y
27
2839XXBFR1637C1XONAME 0121G0066R28-04-2020660521KarnatakaN18559763.75050378.7450378.740Y16-Jun-20Apr-20Y
2939XXBFR1637C1XONAME 0121G0066-TotalR28-04-2020660521KarnatakaN-559763.75050378.7450378.740Y16-Jun-20Apr-20Y
30
3139XXBFR1637C1XONAME 0221G0067R28-04-2020279135KarnatakaN18236555021289.9521289.950Y16-Jun-20Apr-20Y
3239XXBFR1637C1XONAME 0221G0067-TotalR28-04-2020279135KarnatakaN-236555021289.9521289.950Y16-Jun-20Apr-20Y
33
3439XXBCL5745N1X4NAME 02203373280200000R01-04-2020420493KarnatakaN18356350032071.532071.50Y11-May-20Apr-20Y
3539XXBCL5745N1X4NAME 02203373280200000-TotalR01-04-2020420493KarnatakaN-356350032071.532071.50Y11-May-20Apr-20Y
36
3739XBXFS5757L1XXNAME 02SBE-07R05-04-2020306859KarnatakaN18260050023404.523404.50Y25-May-20Apr-20Y
3839XBXFS5757L1XXNAME 02SBE-07-TotalR05-04-2020306859KarnatakaN-260050023404.523404.50Y25-May-20Apr-20Y
39
4039XBXFS5757L1XXNAME 03SBE-08R05-04-20201070333KarnatakaN18907062081635.5881635.580Y25-May-20Apr-20Y
4139XBXFS5757L1XXNAME 03SBE-08-TotalR05-04-20201070333KarnatakaN-907062081635.5881635.580Y25-May-20Apr-20Y
42
4339XXXCB3894G1XJNAME 01BM2129I000154604R03-04-202010864KarnatakaN189206.780828.61828.610Y11-May-20Apr-20Y
4439XXXCB3894G1XJNAME 01BM2129I000154604-TotalR03-04-202010864KarnatakaN-9206.780828.61828.610Y11-May-20Apr-20Y
45
4639XXBCD3611Q1XENAME 02BLR204366R08-04-202011034.62KarnatakaN18550049.549.50Y11-May-20Apr-20Y
4739XXBCD3611Q1XENAME 02BLR204366-TotalR08-04-202011034.62KarnatakaN-550049.549.50Y11-May-20Apr-20Y
48
4939XXBCD3611Q1XENAME 02KASIR00118134R30-04-202048598.79KarnatakaN1841185.4103706.693706.690Y11-May-20Apr-20Y
5039XXBCD3611Q1XENAME 02KASIR00118134-TotalR30-04-202048598.79KarnatakaN-41185.4103706.693706.690Y11-May-20Apr-20Y
51
5239XXCCS8676D1XYNAME 029711047324R01-04-20205310KarnatakaN18450004054050Y10-May-20Apr-20Y
5339XXCCS8676D1XYNAME 029711047324-TotalR01-04-20205310KarnatakaN-450004054050Y10-May-20Apr-20Y
54
5539XXCCS8676D1XYNAME 039711047572R30-04-202030537.74KarnatakaN1825879.4402329.152329.150Y10-May-20Apr-20Y
5639XXCCS8676D1XYNAME 039711047572-TotalR30-04-202030537.74KarnatakaN-25879.4402329.152329.150Y10-May-20Apr-20Y
57
5839XIXPG4517H1XNNAME 01882/APEX/20-21R30-04-202069476KarnatakaN0694760000Y31-May-20Apr-20Y
5939XIXPG4517H1XNNAME 01882/APEX/20-21-TotalR30-04-202069476KarnatakaN-694760000Y31-May-20Apr-20Y
60
6139XIXPG4517H1XNNAME 02883/APEX/20-21R30-04-202065017KarnatakaN0650170000Y31-May-20Apr-20Y
6239XIXPG4517H1XNNAME 02883/APEX/20-21-TotalR30-04-202065017KarnatakaN-650170000Y31-May-20Apr-20Y
63
6439XIXPG4517H1XNNAME 02884/APEX/20-21R30-04-2020302844KarnatakaN18256648023098.3223098.320Y31-May-20Apr-20Y
6539XIXPG4517H1XNNAME 02884/APEX/20-21-TotalR30-04-2020302844KarnatakaN-256648023098.3223098.320Y31-May-20Apr-20Y
66
6739XIXPG4517H1XNNAME 02885/APEX/20-21R30-04-202077338KarnatakaN186554005898.65898.60Y31-May-20Apr-20Y
6839XIXPG4517H1XNNAME 02885/APEX/20-21-TotalR30-04-202077338KarnatakaN-6554005898.65898.60Y31-May-20Apr-20Y
69
7039XXXCY3768D1XCNAME 01BBC0404206329630R04-04-2020864763KarnatakaN18732850065956.565956.50Y19-May-20Apr-20Y
7139XXXCY3768D1XCNAME 01BBC0404206329630-TotalR04-04-2020864763KarnatakaN-732850065956.565956.50Y19-May-20Apr-20Y
72
7339XXXFI3788K1XWNAME 020031/2020-21R30-04-202015340KarnatakaN18130000117011700Y13-May-20Apr-20Y
7439XXXFI3788K1XWNAME 020031/2020-21-TotalR30-04-202015340KarnatakaN-130000117011700Y13-May-20Apr-20Y
75
7639XXFCC9473R1XLNAME 02447892945R03-04-202014819.38KarnatakaN1213231.580793.9793.90Y11-May-20Apr-20Y
7739XXFCC9473R1XLNAME 02447892945-TotalR03-04-202014819.38KarnatakaN-13231.580793.9793.90Y11-May-20Apr-20Y
78
7939XXFCC9473R1XLNAME 02447892946R03-04-20204878.72KarnatakaN1243560261.36261.360Y11-May-20Apr-20Y
8039XXFCC9473R1XLNAME 02447892946-TotalR03-04-20204878.72KarnatakaN-43560261.36261.360Y11-May-20Apr-20Y
81
8239BFXPR3739X1XUNAME 03PE-02/2020-21R05-04-2020266404KarnatakaN18225766020318.9420318.940Y08-Jun-20Apr-20Y
8339BFXPR3739X1XUNAME 03PE-02/2020-21-TotalR05-04-2020266404KarnatakaN-225766020318.9420318.940Y08-Jun-20Apr-20Y
84
B2B
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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.?
Book1.xlsx
ABCDEFGHIJKLMNOPQRSTUVWX
1Goods and Services Tax - GSTR 2A
2
3
4 Taxable inward supplies received from registered persons
5GSTIN of supplierTrade/Legal name of the SupplierInvoice detailsPlace of supplySupply Attract Reverse ChargeRate (%)Taxable Value (₹)Tax AmountGSTR-1/IFF/GSTR-5 Filing StatusGSTR-1/IFF/GSTR-5 Filing DateGSTR-1/IFF/GSTR-5 Filing PeriodGSTR-3B Filing StatusAmendment made, if anyTax Period in which AmendedEffective date of cancellationSourceIRNIRN date
6Invoice numberInvoice typeInvoice DateInvoice Value (₹)Integrated Tax (₹)Central Tax (₹)State/UT tax (₹)Cess (₹)
776XXXCU3468F1XGNAME 0111020072192R02-04-202088500KarnatakaN187500013500000Y30-Jun-20Apr-20Y
876XXXCU3468F1XGNAME 0111020072192-TotalR02-04-202088500KarnatakaN-7500013500000Y30-Jun-20Apr-20Y
9
1039XXXCI5569D1XGNAME 02KA2001000353R30-04-202010903.2KarnatakaN1892400831.6831.60Y16-May-20Apr-20Y
1139XXXCI5569D1XGNAME 02KA2001000353-TotalR30-04-202010903.2KarnatakaN-92400831.6831.60Y16-May-20Apr-20Y
12
1339XXXCI5569D1XGNAME 02KA2002000107R20-04-20209440KarnatakaN18800007207200Y16-May-20Apr-20Y
1439XXXCI5569D1XGNAME 02KA2002000107-TotalR20-04-20209440KarnatakaN-800007207200Y16-May-20Apr-20Y
15
1639XXXCI5569D1XGNAME 02KA2002000108R20-04-20209440KarnatakaN18800007207200Y16-May-20Apr-20Y
1739XXXCI5569D1XGNAME 02KA2002000108-TotalR20-04-20209440KarnatakaN-800007207200Y16-May-20Apr-20Y
18
1939XXXCG8733H1XGNAME 03DMB2021/GIS00058R27-04-20201992KarnatakaN121778.560106.71106.710Y06-May-20Apr-20Y
2039XXXCG8733H1XGNAME 03DMB2021/GIS00058-TotalR27-04-20201992KarnatakaN-1778.560106.71106.710Y06-May-20Apr-20Y
21
2239XXXCG8733H1XGNAME 03DMB2021/GIS00070R29-04-20209960KarnatakaN128892.80533.57533.570Y06-May-20Apr-20Y
2339XXXCG8733H1XGNAME 03DMB2021/GIS00070-TotalR29-04-20209960KarnatakaN-8892.80533.57533.570Y06-May-20Apr-20Y
24
2539XXXCG8733H1XGNAME 03DMB2021/GIS00080R30-04-20201000KarnatakaN12892.85053.5753.570Y06-May-20Apr-20Y
2639XXXCG8733H1XGNAME 03DMB2021/GIS00080-TotalR30-04-20201000KarnatakaN-892.85053.5753.570Y06-May-20Apr-20Y
27
2839XXBFR1637C1XONAME 0121G0066R28-04-2020660521KarnatakaN18559763.75050378.7450378.740Y16-Jun-20Apr-20Y
2939XXBFR1637C1XONAME 0121G0066-TotalR28-04-2020660521KarnatakaN-559763.75050378.7450378.740Y16-Jun-20Apr-20Y
30
3139XXBFR1637C1XONAME 0221G0067R28-04-2020279135KarnatakaN18236555021289.9521289.950Y16-Jun-20Apr-20Y
3239XXBFR1637C1XONAME 0221G0067-TotalR28-04-2020279135KarnatakaN-236555021289.9521289.950Y16-Jun-20Apr-20Y
33
3439XXBCL5745N1X4NAME 02203373280200000R01-04-2020420493KarnatakaN18356350032071.532071.50Y11-May-20Apr-20Y
3539XXBCL5745N1X4NAME 02203373280200000-TotalR01-04-2020420493KarnatakaN-356350032071.532071.50Y11-May-20Apr-20Y
36
3739XBXFS5757L1XXNAME 02SBE-07R05-04-2020306859KarnatakaN18260050023404.523404.50Y25-May-20Apr-20Y
3839XBXFS5757L1XXNAME 02SBE-07-TotalR05-04-2020306859KarnatakaN-260050023404.523404.50Y25-May-20Apr-20Y
39
4039XBXFS5757L1XXNAME 03SBE-08R05-04-20201070333KarnatakaN18907062081635.5881635.580Y25-May-20Apr-20Y
4139XBXFS5757L1XXNAME 03SBE-08-TotalR05-04-20201070333KarnatakaN-907062081635.5881635.580Y25-May-20Apr-20Y
42
4339XXXCB3894G1XJNAME 01BM2129I000154604R03-04-202010864KarnatakaN189206.780828.61828.610Y11-May-20Apr-20Y
4439XXXCB3894G1XJNAME 01BM2129I000154604-TotalR03-04-202010864KarnatakaN-9206.780828.61828.610Y11-May-20Apr-20Y
45
4639XXBCD3611Q1XENAME 02BLR204366R08-04-202011034.62KarnatakaN18550049.549.50Y11-May-20Apr-20Y
4739XXBCD3611Q1XENAME 02BLR204366-TotalR08-04-202011034.62KarnatakaN-550049.549.50Y11-May-20Apr-20Y
48
4939XXBCD3611Q1XENAME 02KASIR00118134R30-04-202048598.79KarnatakaN1841185.4103706.693706.690Y11-May-20Apr-20Y
5039XXBCD3611Q1XENAME 02KASIR00118134-TotalR30-04-202048598.79KarnatakaN-41185.4103706.693706.690Y11-May-20Apr-20Y
51
5239XXCCS8676D1XYNAME 029711047324R01-04-20205310KarnatakaN18450004054050Y10-May-20Apr-20Y
5339XXCCS8676D1XYNAME 029711047324-TotalR01-04-20205310KarnatakaN-450004054050Y10-May-20Apr-20Y
54
5539XXCCS8676D1XYNAME 039711047572R30-04-202030537.74KarnatakaN1825879.4402329.152329.150Y10-May-20Apr-20Y
5639XXCCS8676D1XYNAME 039711047572-TotalR30-04-202030537.74KarnatakaN-25879.4402329.152329.150Y10-May-20Apr-20Y
57
5839XIXPG4517H1XNNAME 01882/APEX/20-21R30-04-202069476KarnatakaN0694760000Y31-May-20Apr-20Y
5939XIXPG4517H1XNNAME 01882/APEX/20-21-TotalR30-04-202069476KarnatakaN-694760000Y31-May-20Apr-20Y
60
6139XIXPG4517H1XNNAME 02883/APEX/20-21R30-04-202065017KarnatakaN0650170000Y31-May-20Apr-20Y
6239XIXPG4517H1XNNAME 02883/APEX/20-21-TotalR30-04-202065017KarnatakaN-650170000Y31-May-20Apr-20Y
63
6439XIXPG4517H1XNNAME 02884/APEX/20-21R30-04-2020302844KarnatakaN18256648023098.3223098.320Y31-May-20Apr-20Y
6539XIXPG4517H1XNNAME 02884/APEX/20-21-TotalR30-04-2020302844KarnatakaN-256648023098.3223098.320Y31-May-20Apr-20Y
66
6739XIXPG4517H1XNNAME 02885/APEX/20-21R30-04-202077338KarnatakaN186554005898.65898.60Y31-May-20Apr-20Y
6839XIXPG4517H1XNNAME 02885/APEX/20-21-TotalR30-04-202077338KarnatakaN-6554005898.65898.60Y31-May-20Apr-20Y
69
7039XXXCY3768D1XCNAME 01BBC0404206329630R04-04-2020864763KarnatakaN18732850065956.565956.50Y19-May-20Apr-20Y
7139XXXCY3768D1XCNAME 01BBC0404206329630-TotalR04-04-2020864763KarnatakaN-732850065956.565956.50Y19-May-20Apr-20Y
72
7339XXXFI3788K1XWNAME 020031/2020-21R30-04-202015340KarnatakaN18130000117011700Y13-May-20Apr-20Y
7439XXXFI3788K1XWNAME 020031/2020-21-TotalR30-04-202015340KarnatakaN-130000117011700Y13-May-20Apr-20Y
75
7639XXFCC9473R1XLNAME 02447892945R03-04-202014819.38KarnatakaN1213231.580793.9793.90Y11-May-20Apr-20Y
7739XXFCC9473R1XLNAME 02447892945-TotalR03-04-202014819.38KarnatakaN-13231.580793.9793.90Y11-May-20Apr-20Y
78
7939XXFCC9473R1XLNAME 02447892946R03-04-20204878.72KarnatakaN1243560261.36261.360Y11-May-20Apr-20Y
8039XXFCC9473R1XLNAME 02447892946-TotalR03-04-20204878.72KarnatakaN-43560261.36261.360Y11-May-20Apr-20Y
81
8239BFXPR3739X1XUNAME 03PE-02/2020-21R05-04-2020266404KarnatakaN18225766020318.9420318.940Y08-Jun-20Apr-20Y
8339BFXPR3739X1XUNAME 03PE-02/2020-21-TotalR05-04-2020266404KarnatakaN-225766020318.9420318.940Y08-Jun-20Apr-20Y
84
B2B
Sorry.. found my mistake. Problem solved
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,326
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top