rajnath (accountant) (48 Points)
17 May 2019| 11-04-2018 | Packing Materials GST12 | GST Purchase1819 | 38326.00 | |
| New Ref | GST/647 / 060418 | 60 Days | Cr |
This one of the tally data exported to excel now i want re arrange the yellow color data in single row if any one please help to to do this in excel because its a big data manual it is not possible to do for reconcile purpose its required please help me to do this
Deepak Gupta
(CA Student)
(15922 Points)
Replied 17 May 2019
Can you post the excel data file, if there isn't anything sensitive...
rajnath
(accountant)
(48 Points)
Replied 18 May 2019
Dear sir,
Please find the attached Excel file.
Deepak Gupta
(CA Student)
(15922 Points)
Replied 18 May 2019
rajnath
(accountant)
(48 Points)
Replied 18 May 2019
Sir,
column B Purchase Ledger and Column C is invoice reference number invoice reference sitting in row number 4 if i filter column B inv reference not coming for me Date, Purchase Ledger, Inv Reference, and Inv value should come in row number 3 or row number 4.
Deepak Gupta
(CA Student)
(15922 Points)
Replied 18 May 2019
Sorry... overlooked the voucher number column earlier... kindly see the revised file attached...
Following has been done...
Cut entire voucher number column by clicking on top of the row... paste it in another sheet... remove the topmost blank cell... again cut from there and paste back in the table after clicking on top of the table... that one space issue in every alternate cell will be resolved for filtration... Now you will get the result by filtering the data...
There can be other ways too to resolve this issue... but at present, i could do this way only...
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
